VBA Move Data to different Worksheet if specific cell not empty

TimPin

New Member
Joined
Apr 23, 2019
Messages
20
I have a reservations spreadsheet that I need to transfer data to to another sheet if a cell is not empty using an ActiveX button called TransferNoShows.

I need the following to happen when I press the button:

In Spreadsheet 1 If a cell in I3-I39 is not empty Transfer (append) Data in Cells D, E, F, and G in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2. Then Delete the data in Spreadsheet 1 Column I ONLY.

In Spreadsheet 1 If a cell in S3-S39 is not empty Transfer (append) Data in Cells N, O, P, and Q in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2.Then Delete the data in Spreadsheet 1 Column S ONLY.

Thank you in advance!
 

TimPin

New Member
Joined
Apr 23, 2019
Messages
20
I have a reservations spreadsheet that I need to transfer data to to another sheet if a cell is not empty using an ActiveX button called TransferNoShows.

I need the following to happen when I press the button:

In Spreadsheet 1 If a cell in I3-I39 is not empty Transfer (append) Data in Cells D, E, F, and G in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2. Then Delete the data in Spreadsheet 1 Column I ONLY.

In Spreadsheet 1 If a cell in S3-S39 is not empty Transfer (append) Data in Cells N, O, P, and Q in that row to Columns B, C, D, and E respectively in Spreadsheet 2 then place today's date in column A of spreadsheet 2.Then Delete the data in Spreadsheet 1 Column S ONLY.

Thank you in advance!
Is this not possible?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,720
Office Version
365
Platform
Windows
@TimPin
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

In future please provide the links yourself.
 

TimPin

New Member
Joined
Apr 23, 2019
Messages
20
I posted here first, I hadn't gotten any responses so, because I am on a very tight timeline, I posted elsewhere hoping to get some help. I have withdrawn my request from the other boards.
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,720
Office Version
365
Platform
Windows
You do not need to close the posts on the other sites.
Just remember to supply links, if you do this in the future.
 

TimPin

New Member
Joined
Apr 23, 2019
Messages
20
I would post a copy of the excel file if I could, but I am unable to attache a file to post.
 

Forum statistics

Threads
1,085,457
Messages
5,383,793
Members
401,853
Latest member
Thoro

Some videos you may like

This Week's Hot Topics

Top