Copying only new data to another worksheet
 

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

--
sa0200
-----------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52761

Copying only new data to another worksheet
 

Look at the techniques shown on Chip Pearson's page:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy


"sa02000" wrote:


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 thereby
overwriting previous months data) and worksheet2 has additional data
that is added manually to the new rows.
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


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=527615