Hi all,
I am hoping to put together a macro that will allow me to automatically update files from a database of corresponding files.
I will have one folder of "Scorecards", each of which has a corresponding "Master Document" from which all of its fields can be populated.
Currently, I just have the scorecard as a tab within the Master Document workbook but I need to find a solution that allows them to remain separate documents.
Does anyone know if it is possible for me to write a macro that would for example, in Scorecard A, go into a folder and find the corresponding Master Document A, and automatically update the scorecard from that master document? And then do the same for Scorecard B / Master Document B, Scorecard C / Master Document C etc.
Hopefully I have explained this reasonably, and any help is very much appreciated!
Thanks!
I am hoping to put together a macro that will allow me to automatically update files from a database of corresponding files.
I will have one folder of "Scorecards", each of which has a corresponding "Master Document" from which all of its fields can be populated.
Currently, I just have the scorecard as a tab within the Master Document workbook but I need to find a solution that allows them to remain separate documents.
Does anyone know if it is possible for me to write a macro that would for example, in Scorecard A, go into a folder and find the corresponding Master Document A, and automatically update the scorecard from that master document? And then do the same for Scorecard B / Master Document B, Scorecard C / Master Document C etc.
Hopefully I have explained this reasonably, and any help is very much appreciated!
Thanks!
