ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Returning the formula in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/32972-returning-formula-cell.html)

Sukhjeet

Returning the formula in a cell
 
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



All times are GMT +1. The time now is 04:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com