copy duplicate data from two workbooks into new workbook

**getfunky** · 09-23-2008, 07:12 PM

Hey,

Sorry about thread title, didn't know what function to use to put in the title. I have an issue I can't seem to resolve. This is the scenario:

I have two workbooks open. Column A of workbook1 and column C of workbook2 both contain 'Product ID' numbers. Workbook1 column A has 507 entries while workbook2 column C has 28277 entries (majority of the numbers duplicated). What I'm trying to do is have all the entries in workbook2 Column C that match workbook1 Column A copied and pasted into a new sheet in workbook2.

Plus, is it possible to have columns a to r besides C copied onto that new sheet? For example: A number in Column C of workbook2 matches a number in Column A of workbook1. The entire row in workbook2 that contains the matched number will be copied to the new sheet in workbook2.

I'm so lost on this, I'd really appreciate any help. Thanks a lot!

**Paul** · 09-23-2008, 11:36 PM

Hi getfunky, welcome to the forum.

I'm glad you read and are aware of the forum rule regarding threat titles, but please change it to anything that might seem appropriate. Something along the lines of "copy duplicate data from two workbooks into new workbook" would be better than what you have currently.

**isonj** · 09-24-2008, 02:59 AM

I have a Servers consolidation report I use to clarify a consilidated list from muiltple lists, I have removed the consolidation component. You might be able to use some of these formulas to assist it this. See attached sheet.

**sglife** · 09-24-2008, 04:05 AM

1. Copy the whole sheet of data in workbook2 to a new sheet
2. add a new column beside the Product ID
3. Insert formula to D1 of "Match" , =match(C1,"product id"on workbook1,0)
4. Copy the formula down
5. You can see there are many cells with a "#N/A" result
6. Select all the range, sort by the new column D, then delete all the rows with a "#/A" result
7. After checking your data, delete the new column
Ok, the rest rows are what you need