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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Delete Data
ould be quickest and easiest to actually do that in Access..
But, in Excel, you can combine all account numbers on one worksheet, then highlight your list, go to DataFilterAdvanced Filter, select copy to new location and select unique records only, drop into a new column. "CandiC" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Delete Data
Can you tell me how to do this in Access If I have three separate tables of
information that is actually extracted from our ERP system? "Sean Timmons" wrote: ould be quickest and easiest to actually do that in Access.. But, in Excel, you can combine all account numbers on one worksheet, then highlight your list, go to DataFilterAdvanced Filter, select copy to new location and select unique records only, drop into a new column. "CandiC" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge and Delete Data
sure.. I would run 3 queries... Just doing an append of unmatched to the
source table. And, I am assuming your only output required is customer ID. First, run a query from, say, Repair table, do Make Table and grab only Customer ID. Use Sigma button to group by if you have any duplicate customer id's within this table. In second query, select your newly created table and say, Clean Table. Link by Cust ID (of course), with Join of all records from new and only equal records from Clean. Query will have both cust id fields in it, don't show the Clean table's cust ID, and enter Is Null in the criteria. Group if necessary. run as an Append query. Do the same in your third query, using new table and Diagnose table. Hope that made sense? "CandiC" wrote: Can you tell me how to do this in Access If I have three separate tables of information that is actually extracted from our ERP system? "Sean Timmons" wrote: ould be quickest and easiest to actually do that in Access.. But, in Excel, you can combine all account numbers on one worksheet, then highlight your list, go to DataFilterAdvanced Filter, select copy to new location and select unique records only, drop into a new column. "CandiC" wrote: 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. |
Reply |
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) |