PDA

View Full Version : Macro to compare excel sheets and add missing data



lcon
04-11-2012, 05:40 AM
Hi,
Please help me with a macro that can compare excel files and add missing data. The details are as below

I have 2 excel sheets Master.xls and Update.xls. The Master sheet has around 2000 rows with a specific column structure. The same column structure is also present in Update sheet which has around 500 rows. I want a macro which will compare the rows in both the files based on values in column A, B, C and AI and will add the missing rows in Update Sheet.

The data in the Master sheet might change on a weekly basis and I want the update sheet to be able to compare the data and update it's data based on the Master sheet.

I've tried a couple of macros but none of them seem to work.
Hope the gurus can help me with this issue.

Thanks,
lcon