macro to transfer data to another workbook

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.

hi Mumps1,

yes that's correct.

hi, any reason why im getting an error code, error time error 457: this key is already associated with an element of this collection

Originally Posted by Mumps1

It means that you have duplicate ID's in column C of the Master workbook. Those ID's are supposed to be unique.

Yes,for some reason there was a duplicate. Now resolved