| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect formula not working if I give custom name for Sheets
My sheets names are 1, 2, 3,... 100. I am trying to make a "summery" sheet in
the same work book from cells a6 to j6 from 1 to more than 100 numeric named sheets.The formula =INDIRECT("Sheet" & (ROW()) & "!A6") is working fine if the sheet names are from system default Sheet1, sheet2 sheet3 etc. Now I modified the formula into =INDIRECT("'" & (ROW()) & "!A6") but it returns #REF!. I dont know what is the mistake I am doing! Can any one solve this problem? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect formula not working if I give custom name for Sheets | Excel Discussion (Misc queries) | |||
| Indirect formula not working if I give custom name for Sheets | Excel Discussion (Misc queries) | |||
| Can Formula Auditing give cell refs to other sheets? | New Users to Excel | |||
| Give permanent name to custom format? | Excel Discussion (Misc queries) | |||
| Reset should give a warning before resetting custom colors. | Setting up and Configuration of Excel | |||
Threaded Mode
