| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference other worksheets via variable names
Is it possible to reference another worksheet by entering the name of that
worksheet in an input cell within the current worksheet and referencing this cell within a function in the current worksheet. example: current sheet name "Convert" cell C11 required to be = to cell H5 on another worksheet named either "word" or "report". The typical function would be "=Word!H5" or "=Report!H5" How do I make the "Word!" part of the above function a variable? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Worksheet Names | Excel Worksheet Functions | |||
| creating a variable for file names | Excel Discussion (Misc queries) | |||
| Variable names for named range | Excel Discussion (Misc queries) | |||
| variable file names | Excel Discussion (Misc queries) | |||
| Variable Names in Formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
