Copying only new data to another worksheet

  • Thread starter Thread starter sa02000
  • Start date Start date
S

sa02000

I have two worksheets with partially same data. I need to copy only the
new rows from worksheet1 to worksheet2.
Worksheet1 is updated automatically every month (and thereb
overwriting previous months data) and worksheet2 has additional dat
that is added manually to the new rows.
And if I can highlight the new rows copied into the worksheet2 tha
will be even better.
Is there any easy way to do it or any in-built function in excel that
will do this?

Thanks, Ja
 

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

trigger worksheet activate event in another worksheet 2
Copying the last used cell only 4
Paste into next blank row in a different worksheet 10
Copy a row down a column for the same number of rows of data in another workshee 6
Select Cell in first blank column of a row 2
Go To Worksheet.Cell Referencing Another Worksheet.Cell 2
Search Range for string, then copy that cell to another worksheet 1
VBA Copy Range of cells with a condition to another worksheet 3

Back
Top