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?
|