VBA Move Data to different Worksheet if specific cell not empty

[TimPin]

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]

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?

 

[TimPin]

Please Help!!!

 

[alansidman]

crossposted: https://www.excelguru.ca/forums/sho...ls-basee-on-value-of-another-cell-in-that-row

and

https://www.excelforum.com/excel-pr...sed-on-another-cell-contents.html#post5177417

 

[Fluff]

@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]

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.

 

[Fluff]

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]

Does anyone have any help for me on this?

 

[TimPin]

I would post a copy of the excel file if I could, but I am unable to attache a file to post.