Compare and MERGE 2 Worksheets into One

Closed
Jessica - Aug 30, 2009 at 06:02 PM
 Jessica - Aug 30, 2009 at 06:13 PM
Hello,
I have data in WorkBook #1 which has Columns A, B, C, D, E, and F. I have another Workbook #2 which has Columns A and B. I need to compare the contents of Workbook #2 Column A (string) to the Contents of Workbook #1 Column E (string) and if ANY strings match...ADD the contents of Workbook #2 Column B fo the EXISTING string in Column E, SEPERATED by commas.

I can paste data from the 2 workbooks into ONE WORKBOOK (2 sheets) and have the results show up on a different sheet if this is helpful...they do not need to originate from 2 workbooks.

Can anyone help?

Workbook #1

id file_name level view tags categories
4907 ADRL.JPG 5 5 adrl, driver, drag racing photos
5075 0005.jpg 5 5 2009, fy2009 photos

Workbook #2
Current Tag Tags to be Added
adrl race, track
2009 09

FINAL Workbook #3 (AFTER COMPARE AND MERGE)

id file_name level view_level tags categories
4907 ADRL.JPG 5 5 adrl, driver, drag racing, race, track photos
5075 0005.jpg 5 5 2009, fy2009, 09 photos

Can anyone HELP??

1 reply

Sorry, the data merged...here is a better view....


Workbook #1

id-------file_name-- level----view--- tags--------------------------------- categories
4907---ADRL.JPG----5------- 5------ adrl, driver, drag racing----------- photos
5075---0005.jpg-----5--------5------2009, fy2009------------------------photos

Workbook #2
Current Tag---------------- Tags to be Added
adrl race,--------------------track
2009-------------------------09

FINAL Workbook #3 (AFTER COMPARE AND MERGE)

id------file_name--level---view---tags-----------------------------------------categories
4907--ADRL.JPG---5-------5------adrl, driver, drag racing, race, track-----photos
5075--0005.jpg----5-------5------2009, fy2009, 09-------------------------- photos
1