How do I compare 2 workbooks columns and show duplicates as a new list

[angiee]

hiii,

Anyone please help me with this...I am pretty new to Excel macros.

I have two different workboooks with approx 15 columns and 50k rows in one workbook and 10columns and 1000 rows in another workbook and only 2 columns(partnumber, changelevel)are in common. So i want to pull two reports from these two workbooks.

1. Records with common partnumber & changelevel in to a different workbook as one report
2. I want to delete the common part number & changelevel records from first workbook and copy all the remaining records into a different workbook as another report.


Thanks,
Angiee