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