PDA

View Full Version : Update master workbook if does not match multiple columns



chlin
06-04-2014, 01:03 AM
Hi,

I have two workbooks. One is the master workbook and the other a daily report workbook. If the columns A-C from the master workbook does not match columns I, F & E of the daily report, I want to add this record into the master workbook. There are however some duplicates in the daily report workbook, but the records in the master workbook should be unique.

Please help. Thanks.

chlin
06-23-2014, 12:10 AM
Anybody can help with a macro for this? Thanks.