 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2006Cell/Worksheet references
In Excel, how can I use the contents of a cell in a formula to direct to a specific worksheet. I have several worksheets and I want to extract the contents of a cell on a specific worksheet by using the contents of a cell to name the worksheet. i.e. Suppose I want to access the value of cell F5 on worksheet "sheet1". In cell A1 of the current worksheet is the text "sheet1". So, instead of the formula being "=sheet1!F5" I want it to be "A1!F5" so that, as I change the value of A1, I get the value of cell F5 from a different worksheet.  SignatureDavidRennox Try this: =INDIRECT("'"&A1&"'!F5") SignatureHTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== In Excel, how can I use the contents of a cell in a formula to direct to a specific worksheet. I have several worksheets and I want to extract the contents of a cell on a specific worksheet by using the contents of a cell to name the worksheet. i.e. Suppose I want to access the value of cell F5 on worksheet "sheet1". In cell A1 of the current worksheet is the text "sheet1". So, instead of the formula being "=sheet1!F5" I want it to be "A1!F5" so that, as I change the value of A1, I get the value of cell F5 from a different worksheet. SignatureDavidRennox ------------------------------------------------------------------------ DavidRennox's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36854 View this thread: http://www.excelforum.com/showthread.php?threadid=565621 =indirect("'" & a1 & "'!F5") > In Excel, how can I use the contents of a cell in a formula to direct to > a specific worksheet. [quoted text clipped - 15 lines] > DavidRennox's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36854 > View this thread: http://www.excelforum.com/showthread.php?threadid=565621 SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.