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