I am hoping to link 2 workbooks.
Workbook 1 is the source and 2 is destination. This works perfectly when I set up as master. Workbook 2 reads from workbook 1.
However, i need a way to constantly make different name changes to workbook 1. Each time the workbook needs to be saved with a new name. It will change from Master to eg smith then jones.
Obviously with standard set up the Workbook 2 no longer reads from these with a name change.
Is there anyway to do this so I always have a secondary workbook 2 reading from workbook 1 with new name?