I am trying to set the hyperlink box so that it automatically reverts to a particular drive and folder to retrieve the file from. Is there a way to do this?
I have a spreadsheet that requires a hyperlink to an accompanying file on a shared drive for every entry. So for each hyperlink that needs entered I need the hyperlink box to start at O:/shared folder/Estimates/Sent Complete/
Once here the users can choose the saved files that they need linked to.
TIA
tnemom
I have a spreadsheet that requires a hyperlink to an accompanying file on a shared drive for every entry. So for each hyperlink that needs entered I need the hyperlink box to start at O:/shared folder/Estimates/Sent Complete/
Once here the users can choose the saved files that they need linked to.
TIA
tnemom