G
Guest
Can you use the hyperlink function to point to cell within same workbook?
I'm using Excel 2003.
I don't want to use Insert/Hyperlink feature because I have about 100
hyperlinks that I need to be able to easily edit - using find/replace (can't
do this with Insert/Hyperlink)
Here's a sample of what I've got:
=HYPERLINK('Test sheet'!A60,"return")
From another worksheet, click on the cell with "return" and then it should
take me to cell a60 in test sheet.
Thanks, Mary-Lou
I'm using Excel 2003.
I don't want to use Insert/Hyperlink feature because I have about 100
hyperlinks that I need to be able to easily edit - using find/replace (can't
do this with Insert/Hyperlink)
Here's a sample of what I've got:
=HYPERLINK('Test sheet'!A60,"return")
From another worksheet, click on the cell with "return" and then it should
take me to cell a60 in test sheet.
Thanks, Mary-Lou