Excel VBA Automation task

Question

Have just started playing around with Macros and VBA, looking for an answer to the following:

I have a master excel sheet which gets sent out to other users who then fill in some of the empty columns each month. I then collate all the information from each individual spreadsheet and put this into the master.

Columns A to K will remain the same and L to R are updated as necessary. In column C there is a unique reference relating to each row so idea is my master will automatically update when I run the macro to fill in L to R of the master for any of the sub workbooks which have been amended based on column C being the same in the master and relevant sub workbook.

I plan on saving the workbooks in one file, with the master sheet and then a sub folder for each copy of the sheet that will be updated by my colleagues.

Hope this makes sense, if not will try and provide more info. (if possible can I have a step by step walkthrough of implementing the code and how it works)

Thanks

Answer 1

Without file to test, it may have some bugs in code.

You may upload file in private message.

Answer 2

I cannot share from a one drive, is it possible to share some code for me to try, if you need more information on the task let me know

Answer 3

You can create a file with dummy data only for test code.

Answer 4

Hello,

I was more looking for help with the VBA Code I can enter into a module? I am unable to share any files.

Answer 5

Could you share us test files to test macros？

For sharing a sample workbook, upload to OneDrive or any other cloud drives. Then post a link here.

From your description, it also could be done with power query.