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.
|