Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

I want to hyperlink a worksheet from a worksheet containing a cell A1 having name of the sheet to be hyperlinked & friendly name.

For example I have a worksheet summary with Cell A1 having its value as "1" & I have a worksheet named "1" to be hyperlink from summary & the friendly name is same as the worksheet to be hyperlinked.

share|improve this question
This is very hard to understand - are you basically saying you want to link to a worksheet, where the hyper link name matches the work sheet name? – Dave Rook Oct 8 '12 at 11:10

1 Answer

up vote 0 down vote

You can use the HYPERLINK function. 

=HYPERLINK(link_location,friendly_name)

Here is the source for more information how to use this formula.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.