Select Cell in first blank column of a row
 

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
--
dhunter43
The Performance Advantage, LLC

Select Cell in first blank column of a row
 

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

"dhunter43" wrote:

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
--
dhunter43
The Performance Advantage, LLC

Select Cell in first blank column of a row
 

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.
--
dhunter43
The Performance Advantage, LLC


"JLGWhiz" wrote:

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

"dhunter43" wrote:

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
--
dhunter43
The Performance Advantage, LLC