| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Delete Data
I have a 3 worksheets of customer data that I have extracted from Access. I
need to create a single worksheet that can merge the data in all three worksheets and delete any duplicate customers. For instance, Work Sheet 1- Column A (customer number) Column B (project label- Repair) Work sheet 2- Column A (customer number) Column B (project label- Clean) Work sheet 3- Column A (customer number) Column B (project label- Diagnose) Some customers may appear in all three work sheets. I need to create a worksheet that will only include each customer once, the project label isn't important at this time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to calculate, merge, and delete | Excel Worksheet Functions | |||
| Turn on merge, insert and delete buttons | Excel Discussion (Misc queries) | |||
| Merge then delete cells | Excel Worksheet Functions | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| How do I delete the line between 2 cells and merge them into one . | Excel Discussion (Misc queries) | |||
Threaded Mode
