cell values as worksheet reference

's Computer Specifications

Hi,

references to cells in a different worksheet look like this, e.g.:

='worksheet'!$A$1

In this formula I want to replace 'worksheet' by the value of a cell,
e.g. $B$1, of the current worksheet, in which stand the text
'worksheet', such that the above formula
becomes something like
=$B$1!$A$1

How does that work? The example doesn't.

thanks,

joerg

's Computer Specifications

have a look at INDIRECT()

For example:

if you have 'wsname' in a2

then =indirect(A2&"!B54")

will give you the contents of wsname!B54 which I think is what you are
looking for

Regards
Reg

"Joerg Schaber" wrote:

> Hi,
>
> references to cells in a different worksheet look like this, e.g.:
>
> ='worksheet'!$A$1
>
> In this formula I want to replace 'worksheet' by the value of a cell,
> e.g. $B$1, of the current worksheet, in which stand the text
> 'worksheet', such that the above formula
> becomes something like
> =$B$1!$A$1
>
> How does that work? The example doesn't.
>
> thanks,
>
> joerg
>

's Computer Specifications

in cell C13 we have:
Sheet2!

In another cell:
=INDIRECT(C2 & "A1")
--
Gary''s Student - gsnu200771

"Joerg Schaber" wrote:

> Hi,
>
> references to cells in a different worksheet look like this, e.g.:
>
> ='worksheet'!$A$1
>
> In this formula I want to replace 'worksheet' by the value of a cell,
> e.g. $B$1, of the current worksheet, in which stand the text
> 'worksheet', such that the above formula
> becomes something like
> =$B$1!$A$1
>
> How does that work? The example doesn't.
>
> thanks,
>
> joerg
>

's Computer Specifications

Thanks! it works!

Reg wrote:
> have a look at INDIRECT()
>
> For example:
>
> if you have 'wsname' in a2
>
> then =indirect(A2&"!B54")
>
> will give you the contents of wsname!B54 which I think is what you are
> looking for
>
> Regards
> Reg
>
>
> "Joerg Schaber" wrote:
>
>> Hi,
>>
>> references to cells in a different worksheet look like this, e.g.:
>>
>> ='worksheet'!$A$1
>>
>> In this formula I want to replace 'worksheet' by the value of a cell,
>> e.g. $B$1, of the current worksheet, in which stand the text
>> 'worksheet', such that the above formula
>> becomes something like
>> =$B$1!$A$1
>>
>> How does that work? The example doesn't.
>>
>> thanks,
>>
>> joerg
>>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying worksheet A values into worksheet B - missing cell values	huge_ness	Microsoft Excel Programming	16	24th Sep 2009 08:00 PM
Build a reference to another worksheet from cell values in currentsheet	Lucas Reece	Microsoft Excel Worksheet Functions	3	18th Feb 2009 09:27 PM
Re: Build a reference to another worksheet from cell values incurrent	Lucas Reece	Microsoft Excel Worksheet Functions	1	17th Feb 2009 10:16 PM
cell values as worksheet reference	Joerg Schaber	Microsoft Excel Discussion	2	29th Feb 2008 04:52 PM
Worksheet reference (i.e placing worksheet name in a cell)	=?Utf-8?B?Um9nZXIgUm9nZXI=?=	Microsoft Excel Worksheet Functions	1	20th Jan 2005 03:40 PM