Hi
I have umpteen sheets in my excel, so I think it would be very useful if I
could have hyperlinks to each of these sheets on the summary page.
Let us say I have, in Sheet 1, Cell A1 the formula "=Sheet2!A2". Lets also
say that Cell Sheet2!A2 contains "Hello"
In colum 2 (B1), i want to be able to use the HYPERLINK formula - if I click
on this cell, it shud take me to Sheet 2
I want to pick up the text "Sheet2!A2" from A1 and not the value returned by
"=Sheet2!A2"(which is "Hello").

Which formula would I use to pick up the formula in cell Sheet1!A1 instead
of the text being displayed there?

Ciao
Sukhjeet