Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare two sheets and combine into one | Excel Worksheet Functions | |||
Counting dates in multiple work sheets and work books | Excel Discussion (Misc queries) | |||
Combine to Sheets... | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
HELP!!! combine 4 different sheets ??? | Excel Discussion (Misc queries) |