Select Cell in first blank column of a row

[dhunter43]

I have code that copies a range from worksheet1, selects worksheet2, then
finds the last row of data and pastes the new data into the first blank row.
What I need now is to copy data from worksheet3 (in a different workbook),
find the last row of data in worksheet2 and paste the data into the first
blank column at the end of the last row of data.
In essence combining data from worksheets 1&3 into the next blank row of
worksheet2.

Thank you

 

[JLGWhiz]

You do it just like WS1, only you chant the references to
Workbooks("DifferentOne").worksheets(3).Range("RangeToCopy").

 

[dhunter43]

I thought so except the data from worksheet3 is overwriting the data from
worksheet1 in columns "A:F" instead of going to the first blank column "AG"
and populating the data there.