excelnovic
New Member
- Joined
- Feb 25, 2009
- Messages
- 1
Hello friends,
I am in desperate need for help with a macro (just beginning to learn to write them).
I have an excel file (COMP1) which has several hundred rows (records), with 12 columns each. The other excel file (COMP2) has 20+ worksheets with the same number of columns. One or more of the worksheets in COMP2 may have records that are identical to COMP1. I would like a macro that reads reach row in COMP1, and looks for match in COMP2. I would like it report DUPLICATES (record every occurrence after the first one) or if NO MATCH FOUND (write the record that was not found), preferably on a different worksheet. I have some 40+ COMP1 files to process.
Can someone kindly help me with this?
Thank you very much in advance as this will save me hours of error-prone work.
Sam.
I am in desperate need for help with a macro (just beginning to learn to write them).
I have an excel file (COMP1) which has several hundred rows (records), with 12 columns each. The other excel file (COMP2) has 20+ worksheets with the same number of columns. One or more of the worksheets in COMP2 may have records that are identical to COMP1. I would like a macro that reads reach row in COMP1, and looks for match in COMP2. I would like it report DUPLICATES (record every occurrence after the first one) or if NO MATCH FOUND (write the record that was not found), preferably on a different worksheet. I have some 40+ COMP1 files to process.
Can someone kindly help me with this?
Thank you very much in advance as this will save me hours of error-prone work.
Sam.
Last edited:
