I want to create a hyperlink in my excel file that points to a specific
document. I same the master excel file to a new folder for every project I
do. The document I hyperlink to also is new for every project. How do I
automaticaly change the hyperlink to reflect the new folder / file location?
I wanted to set it up so that when I performed a "save as" on the master
document it would automatically change the hyperlink path to the new folder
location.