Copy only new rows

[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 if I can highlight the new rows copied
into the worksheet2 that will be even better.
Is there any easy way to do it or any in-built function in excel that
will do this?

Thanks, Jay

 

[Dave Peterson]

There's nothing built in (well, select|copy and paste is).

But maybe you could pick out a column (date???) and use that to determine the
new/old status.

Then apply data|filter|autofilter to that column
show just the new rows
and copy|paste them to their new location.