I would like to reference a cell to obtain a worksheet name rather than have
the worksheet name in the formula. So rather than have Sheet1! in the formula
I would like to have a cell that contains the text "Sheet1"

Check out the Indirect function.

Regards,
Fred

"pv6901" wrote in message
...
I would like to reference a cell to obtain a worksheet name rather than
have
the worksheet name in the formula. So rather than have Sheet1! in the
formula
I would like to have a cell that contains the text "Sheet1"

If A1 contains the text: Sheet1
and you wanted to retrieve the value from Z99 in Sheet1, you could use this
formula:

=indirect("'" & a1 & "'!z99")

If you need to retrieve data from worksheet in a different workbook, be aware
that that "sending" workbook has to be open for =indirect() to work the way you
want.

pv6901 wrote:

I would like to reference a cell to obtain a worksheet name rather than have
the worksheet name in the formula. So rather than have Sheet1! in the formula
I would like to have a cell that contains the text "Sheet1"

--

Dave Peterson

Hi,

There'sno guarantee it makes you formula simpler but lets say we have

Sheet1!

in Cell A1, this formula returns A1 of sheet 1

=INDIRECT(A1&"A1")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"pv6901" wrote:

I would like to reference a cell to obtain a worksheet name rather than have
the worksheet name in the formula. So rather than have Sheet1! in the formula
I would like to have a cell that contains the text "Sheet1"