| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
Try this:
=INDIRECT("'"&A1&"'!F5") -- HTH, RD ===================================================== Please keep all correspondence within the Group, so all may benefit! ===================================================== "DavidRennox" <(E-Mail Removed)> wrote in message news  (E-Mail Removed)...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. -- DavidRennox ------------------------------------------------------------------------ DavidRennox's Profile: http://www.excelforum.com/member.php...o&userid=36854 View this thread: http://www.excelforum.com/showthread...hreadid=565621 |
|
|
|
|
|||
|
Guest
Posts: n/a
|
|
|
|
|
||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Filling in worksheet cell references | Wavequation | Microsoft Excel Misc | 6 | 20th May 2009 06:08 PM |
| Filling in worksheet cell references | Wavequation | Microsoft Excel Misc | 0 | 20th May 2009 05:18 PM |
| Changing Cell References To a Different Worksheet in the Same Cell | =?Utf-8?B?REw=?= | Microsoft Excel Worksheet Functions | 3 | 30th Mar 2006 11:18 PM |
| Cell References from old worksheet to new worksheet. | =?Utf-8?B?UmF5IEVsaWFz?= | Microsoft Excel Misc | 6 | 9th Dec 2005 01:46 AM |
| worksheet cell references | =?Utf-8?B?SlQgU3BpdHo=?= | Microsoft Excel Discussion | 4 | 3rd Jun 2005 10:15 PM |
