Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 Oct 8 '12 at 11:10

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .