Merging two books
 

Hi all

I have a "Master" list which I am storing historical data in. I ge
data to add to this on a weekly basis. But the information on the ne
list may be on the "master" list already.

I am looking for a way to add the new data to the "master" list an
include the duplicates...BUT to make sure that all the informatio
outside of column "A" has been deleted.

Thanks for any help

Davi

--
DB10
-----------------------------------------------------------------------
DB100's Profile: http://www.excelforum.com/member.php...nfo&userid=917
View this thread: http://www.excelforum.com/showthread.php?threadid=27740