Insert sheet linkage

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Learn-more - 07 May 2008 11:14 GMT

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

Reply to this Message

Pete_UK - 07 May 2008 11:55 GMT

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 <Learnm...@discussions.microsoft.com>
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
[quoted text clipped - 7 lines]
>
> Thank you

Reply to this Message

Learn-more - 08 May 2008 03:20 GMT

It works, thank you very much.

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

Thanks.

> Change your formula to this:
>
[quoted text clipped - 21 lines]
> >
> > Thank you

Reply to this Message

David Biddulph - 08 May 2008 09:14 GMT

Try Excel help.
--
David Biddulph

> It works, thank you very much.
>
[quoted text clipped - 31 lines]
>> >
>> > Thank you

Reply to this Message

Pete_UK - 08 May 2008 09:18 GMT

You're welcome - thanks for feeding back.

Pete

On May 8, 3:20 am, Learn-more <Learnm...@discussions.microsoft.com>
wrote:

> It works, thank you very much.
>
> My next job is to figure out how the function INDIRECT works.
>
> Thanks.

Reply to this Message