Copy Data from multiple workbooks to master workbook

Place this macro in a regular module in the Master workbook and save the file as a macro-enabled file so its extension changes to "xlsm". Do this before you run the macro. Once saved, run the macro.

Please Login or Register  to view this content.

Try the attached file. I tested it using the four District files you posted and I didn't get an extra "title" line at the last row.

Since the macro is working properly when I use the files you posted, I cannot determine what is causing the problem. The error is most likely caused because the actual files you are using are organized differently from those you posted. Are they different? When you get the error and when you click "Debug" which line of code is highlighted? What do you mean by "Only new entries/data be updated?"

Hi

Sorry for the misunderstanding.

There is another file in Master Sales.xlsx file in the folder. The first set of code works wonders. Thank you for the great assistance.

However, if I run the macro twice, the same data from the various workbook are updated or copied into this Master Sales Worksheet twice.

Kindly help with only copy new data from the various workbooks into this Master Sales Workbook.

Thank you and regards.

Try:

Please Login or Register  to view this content.

My pleasure.