Using a Macro to Automatically Update Files from a Database

[McCarthy]

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!