Use worksheet name in one cell as part of reference in other cells
What are the odds that of the 2 replies so far both use the *exact* same
*incorrect* formula!
Try this:
A1 = some sheet name like Sheet2
To refer to cell A1 on Sheet2:
=INDIRECT("'"&A1&"'!A1")
--
Biff
Microsoft Excel MVP
"Steamer" wrote in message
...
I want to specify a worksheet name in one cell then use that name as part
of
the reference address in a number of other cells.
Or, to put it another way, I want a number of cells to refer to various
cells in another worksheet, where I specify the name of that worksheet by
typing it into a single cell.
Is this possible in Excel?
|