| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet referencing in a cell
I had an earlier post and thought I had an answer. I am trying to reference a
sheet in a workbook in a cell from a different sheet using the sheet position for the reference. i.e. =sheet(1)A20 i received a reply that =INDIRECT(SHEETNAME(1) & "A3") would do this for me. Unless is used it incorrectly, I get a #value when using the Indirect function as shown. I am using Office 2003, not 2007 if that makes a difference. Thanks in advance. -- jwm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing every 5th cell in another sheet | Excel Worksheet Functions | |||
| referencing to a sheet that it`s name is stored on a cell | Excel Worksheet Functions | |||
| odd behavior when referencing a cell on another sheet | Excel Discussion (Misc queries) | |||
| referencing Excel sheet name in cell | Excel Worksheet Functions | |||
| referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Threaded Mode
