In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.

I tried a few things buy didn't work, hope someone can give me a solution.

Thank you

Change your formula to this:

=INDIRECT("'"&A2&"'!A3")

with your sheet name in A2. Note the apostrophes -
<quotes<apostrophe<quotes and <quotes<apostrophe<exclamation
mark.

Hope this helps.

Pete

On May 7, 11:14*am, Learn-more
wrote:
In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.

I tried a few things buy didn't work, hope someone can give me a solution.

Thank you

It works, thank you very much.

My next job is to figure out how the function INDIRECT works.

Thanks.


"Pete_UK" wrote:

Change your formula to this:

=INDIRECT("'"&A2&"'!A3")

with your sheet name in A2. Note the apostrophes -
<quotes<apostrophe<quotes and <quotes<apostrophe<exclamation
mark.

Hope this helps.

Pete

On May 7, 11:14 am, Learn-more
wrote:
In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.

I tried a few things buy didn't work, hope someone can give me a solution.

Thank you

Try Excel help.
--
David Biddulph

"Learn-more" wrote in message
...
It works, thank you very much.

My next job is to figure out how the function INDIRECT works.

Thanks.


"Pete_UK" wrote:

Change your formula to this:

=INDIRECT("'"&A2&"'!A3")

with your sheet name in A2. Note the apostrophes -
<quotes<apostrophe<quotes and <quotes<apostrophe<exclamation
mark.

Hope this helps.

Pete

On May 7, 11:14 am, Learn-more
wrote:
In a workbook, I have 2 sheets "xyz" and "abc".
If in sheet "xyz" cell a1 I have this formula =abc!a3, then it will
return
the content of sheet "abc" cell a3.
However, instead of putting down "abc" in the formula, I want to put
down
"abc" in sheet "xyz" cell a2 and have the formula in cell a1 to refer
to it,
buy doing so, later on I can put different sheet name on it and get the
required data from other sheets.

I tried a few things buy didn't work, hope someone can give me a
solution.

Thank you

You're welcome - thanks for feeding back.

Pete

On May 8, 3:20*am, Learn-more
wrote:
It works, thank you very much.

My next job is to figure out how the function INDIRECT works.

Thanks.