Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |