View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
sa02000[_14_] sa02000[_14_] is offline
external usenet poster
 
Posts: 1
Default 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