| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two Worksheets similar data
Hi
I have two worksheets in the same workbook, contact names, addresses etc. However I know there are duplicates between the two worksheets. Ideally what I am looking for is that I can consolidate the worksheets and remove duplicate entires. I have tried the unique Advanced Filter and that didnt work and I am so struggling being a newbie to Excel, and here I am 1 day on and no further forward. Can someone please help me out here Many thanks Julie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| Sharing data across worksheets within a workbook based on identifi | Excel Discussion (Misc queries) | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Comparing data in two similar worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
