Link to home
Start Free TrialLog in
Avatar of Wonderwall99
Wonderwall99

asked on

Mass hyperlink to individual workbooks

Hi,

I have a ton of spreadsheets I need to hyperlink and wondering if there is a way to do this without manually updating each hyperlink.  For example, on the 'Test List' xls, column B will hyperlink to each respective workbook.  I created the 'Test A' xls as an example of where the hyperlink will route to.  Is there any way do this without manually updating each hyperlink?  The actual xls will have over 200 workbooks I need to hyperlink to.
Test-List.xlsx
Test-A.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wonderwall99
Wonderwall99

ASKER

I tried changing the location to point to the location on my computer but when I clicked on the hyperlink I received an error.  Any ideas on how I can click on the hyperlink to get to the file location on my computer?
Avatar of Wonderwall99
Wonderwall99

ASKER

Thanks for your help!  I found the correct path and was able to use the formula you provided.