Automatically copy a row

[bpflyr]

I have posted a similar question to this, but I think this approach may be easier...I hope.

Is there a way to have Excel automatically copy a row of data from Workbook1 (about 5 rows) to Workbook2 (about 4000 rows) into the next blank rows? I plan to erase Workbook1 each time (to keep the workbook small) and need Workbook2 to remember the data it just copied.

Some of the cell addresses will be different too. I.e. go from A1 in Workbook1 to C1 in Workbook2.

Is this possible and how? If not, please tell me so I don't go posting the same question again. Thank you very much.

 

[BrianB]

I don't think that there is a suitable definitive answer to this because you have not defined exactly how you choose the column destination.

My code in this link is a bit more than you need, but does show the overall principle for copying unknown lengths of data to a master sheet.

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=