Select Cell in first blank column of a row

G

Guest

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
 
G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste into next blank row in a different worksheet 10
Need Help with code to "Paste into next available row" 3
select column, cut and paste it to new worksheet 1
Slow code when used as VBA code instead of macro (copying visible columns) 3
Using cell value to reference another cell 2
matching multiple columns on different worksheets 1
Prior macro not working in new location after some alterations 1
Copy a row down a column for the same number of rows of data in another workshee 6

Top