hello. I have a master workbook that needs updating weekly and I've tried to create a macro but I have had no success so any help will be much appreciated
my master workbook has all my data and I export data from my system weekly and it has up-to-date information. I would like the macro to run a loop of all the rows in the weekly report and copy and paste the new rows to my master workbook by identifying the new codes in column C (unique ID). the macro will also need to update column N & O in the master workbook if the date is changed in the weekly report.
I have attached 2 workbook samples. please note, the master workbook has more columns.
master workbook sample.xlsxweekly report sample.xlsx
thank you for taking the time to help me.
Bookmarks