Hi,
I have a worksheet and column A contains a list of all the other worksheets which appear in the workbook. Once all the data has been filled in column A I would like to run a macro which changes the text to a hyperlink, linking to the worksheet.
e.g. A2 = "Source Data", A3 = "Summary"
Once the macro is complete the text will still read the same in each cell, but it will now be a hyperlink to the worksheet called Source Data/Summary etc...
I have some code, but it adds a hyperlink to a file rather than a worksheet, I can't figure out how to change the hyperlink type.
Bookmarks