I have 2 separate workbooks of data. The "new" one has 1000 rows of data. The "old" one has 750 rows of data. They both have the same exact columns. I need to look at the data in column "C" which is a unique part number. Match the old data with the new data. For example: If row 25 in the old one has part number 123 and row 35 in the new one has part number 123, I need to copy the entire row from the old to the new. I guess I can use a Lookup table, but I'm not sure how to tackle this.
So after matching the old with the new, there will be 250 rows that do not have data.
HELP!
I hope that I'm explaining this so it's understood.
Any help is greatly appreciated