combine two work sheets -NTW
Dear all,
Could someone help me here please. Ive got two working sheets in exact same format. These two sheets have been updated by two person. Obviously, there are some duplicates. The question is how could I merge those two sheets together and delete the duplicates. (I know the traditional way is to sort them and delete it) Is there any quicker way to do it? Many thanks. |
combine two work sheets -NTW
Hi,
take a look at CPearson web http://www.cpearson.com/excel/MergeListsToDistinct.aspx if this helps please click yes thanks "Sonny" wrote: Dear all, Could someone help me here please. Ive got two working sheets in exact same format. These two sheets have been updated by two person. Obviously, there are some duplicates. The question is how could I merge those two sheets together and delete the duplicates. (I know the traditional way is to sort them and delete it) Is there any quicker way to do it? Many thanks. |
All times are GMT +1. The time now is 09:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com