| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet name variables
I have a project that requires me to copy mutiple worksheets to one hub
worksheet. Is there a way to make the worksheet name a variable? This is what i have so far: =IF(Period8224a!$R$9=$C$2,Period8224a!$N$9,0) The Period8224a name will change like 50 to 100 times. If there was a way to reference the name of the sheet from a cell on the hub sheet like this: =IF("X1"!$R$9=$C$2,"X1"!$N$9,0) with the "X1" cell containing the worksheet name. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create an automatic worksheet with two variables | Excel Worksheet Functions | |||
| populating a master worksheet with variables in other worksheets | Excel Worksheet Functions | |||
| Counting multiple variables in a worksheet for summary on another | Excel Worksheet Functions | |||
| constructing (complex) variables with worksheet functions | Excel Discussion (Misc queries) | |||
| Worksheet template variables | Excel Worksheet Functions | |||
Threaded Mode
