Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Two Spreadsheets
I need to merge two spreadsheets containing product listings. The first has
the headings: U/M PRODUCT# BRAND DESCRIPTION U/M2 DEALER A DEALER B DEALER C The second has the headings: U/M PRODUCT# BRAND DESCRIPTION U/M2 DEALER PRICE Each has many of the same entries, but each has unique entries also. The Product #'s are alphanumeric. I need to combine all the entries, check for duplicate product #'s, and then I will manually delete the rows I don't wish to keep. Any suggestions? Thank you. Ruth |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Two Spreadsheets
Ruth,
I assume this is a one time effort, so I propose a manual approach. I would first format the first file to match the format of the second file. This can be easily done by repeating three times the following operations (each time using the proper dealer A, B or C) column: 1. Copy the range to a blank sheet 2. Insert a column Dealer at the right place and fill it with the dealer name (A, B or C) 3. Delete the two irrelevant dealer columns with prices 4. Sort by prices and remove the lines without prices Once this is done, I would merge the four sheets in one with cut and paste, then sort by product name and dealer name and manually delete the uneeded rows. Stephane |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Two Spreadsheets
Stephane,
Thank you for the reply. I think that will work. "Stephane Quenson" wrote: Ruth, I assume this is a one time effort, so I propose a manual approach. I would first format the first file to match the format of the second file. This can be easily done by repeating three times the following operations (each time using the proper dealer A, B or C) column: 1. Copy the range to a blank sheet 2. Insert a column Dealer at the right place and fill it with the dealer name (A, B or C) 3. Delete the two irrelevant dealer columns with prices 4. Sort by prices and remove the lines without prices Once this is done, I would merge the four sheets in one with cut and paste, then sort by product name and dealer name and manually delete the uneeded rows. Stephane |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merge Two Spreadsheets
Hi,
Do the following: 1. Select range of data in the Second sheet. 2. On the Data menu, point Filiet , and then click the Advanced Filter. The Advanced Filter dialog is displayed. 3. Under Action, click Copy to another location. 4. Click the Unique Records only Chceck box. 5. Click OK to return to the Worksheet. 6. Copy records from the Filtered data and paste in the Sheet 1. For more information about how to use Advanced Filter, please refer to the topic on Advanced Filter in the Microsoft Excel online help. Challa Prabhu "Ruth" wrote: I need to merge two spreadsheets containing product listings. The first has the headings: U/M PRODUCT# BRAND DESCRIPTION U/M2 DEALER A DEALER B DEALER C The second has the headings: U/M PRODUCT# BRAND DESCRIPTION U/M2 DEALER PRICE Each has many of the same entries, but each has unique entries also. The Product #'s are alphanumeric. I need to combine all the entries, check for duplicate product #'s, and then I will manually delete the rows I don't wish to keep. Any suggestions? Thank you. Ruth |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge several spreadsheets into one big spreadsheet | Excel Discussion (Misc queries) | |||
merge 2 spreadsheets info to 1 | Excel Worksheet Functions | |||
Compare/Merge 2 spreadsheets | Excel Discussion (Misc queries) | |||
merge 2 spreadsheets | Excel Discussion (Misc queries) | |||
Merge two Excel 2000 spreadsheets | Excel Discussion (Misc queries) |