Reconciliation of Data in two spreadsheets

Dear Team,

Please help me create a Macro for reconciliation of data in the two attached spreadsheets. The spreadsheet 'Data1' has the actual data and the spreadsheet 'Changes' has the changes listed in the Column A. I need to create 3 tabs in the spreadsheet (either same or new) namely Deleted, Changed, Newly Created. The three tabs should contain deletions, changes & new creations respectively)
The attached file is an extract of the file whereas the actual files has anywhere between 5000 to 6000 line items.

Thanks

What is the primary key for the records?

Hi,
The primary key will be the column code (column K) in file "Data1" & Column L in file "Changes". For easy identification I have renamed the coumns as Unique Code in both the spreadsheets and attached them once again. Hope this helps

Let me restate the requirement so I am sure I understand.

You want to look at the Data file and compare it with the Changes file and you want to prepare three lists
-Deleted - these are records in the data file that are not in the changes file
-Changed - these are records in the data file that have different information in them than the changed files
-Newly Added - these are records in the Changes file that are not in the Data file.

You do NOT want a list of records in the data file that are not changed.

As for Column A in the changes file: do you fill this in, or are you expecting the program to fill this in?

I think this should do it for you.
- In Cells B1 & B2, enter in the path names to where the data and change files are. They can be in the same path.
- In Cells B4 & B5, enter in the file names for the data and changes files.

Click on Clear Old Data to clear out old data if you wish.
Click on Compare Lists to generate the lists.