Insert sheet linkage

L

Learn-more

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
 
P

Pete_UK

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
 
L

Learn-more

It works, thank you very much.

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

Thanks.
 
D

David Biddulph

Try Excel help.
--
David Biddulph

Learn-more said:
It works, thank you very much.

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

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top