| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Reference a cell to get worksheet name
I am trying to reference a cell with worksheet names which is populated from
another formula. Once I have the worksheet name I am then trying to use it in a formula as follows to be used for a dynamic chart. I posted in the Charts forum but got no answer. Is this possible and if so am I on the right track? this would be used for XValues =OFFSET((INDIRECT(""& M2 &"' !$B$4")),0,0,COUNTA(INDIRECT(""& M2 &"' !$B:$C))-1,2) Thanks for any assistance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| name of another worksheet in cell for reference | Excel Worksheet Functions | |||
Threaded Mode
