GA81848
Board Regular
- Joined
- Apr 25, 2005
- Messages
- 124
I have a spreadsheet called Master which is currently linked to a file called Customer. In another directory I have over 500 files which are identical in format as the Customer file.
I need to change the link of the Master file by clicking on a button then being able to select the folder and then the file I want to link to. Is this possible and if so how?
I've tried searching this forum but am unable to find a solution.
I need to change the link of the Master file by clicking on a button then being able to select the folder and then the file I want to link to. Is this possible and if so how?
I've tried searching this forum but am unable to find a solution.