Hi Aaron,
You don't need macro for this. A LOOKUP formula in the master spreadsheet pointing to the update spreadsheet should do the job. Without more details of the layout & workbook names, etc, specific advice can't be given.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|