Linking to another worksheet

[Andrew Stephen]

Hi

I am not sure I am go to explain this correctly, but I will try my best.

I have a workbook with a number of worksheets called week 1, week 2 up to
week 52.

I then have a summary sheet that is used to summarise data from the various
weeks. In the summary worksheet I have a column listing the weeks

ie
B
5 Week 1
6 Week 2
7 Week 3
etc

and what I would like to do is use the name of the week to link to the
worksheets rather then using say ='Week 2'!T$27 as I have approx 50 cells
that I summarise the day and would like to make adding of a new week a
little easier.

I hope I have explained this OK and appreciated any suggestions.

Cheers
Andrew

[Ron de Bruin]

hi Andrew

You can use indirect

With the sheet names in B

=INDIRECT("'" & B1 &"'!A1")


If your sheet names are Week 1, Week 2..... Week 52 you can also use this
Then copy this formula in A1 and copy down

=INDIRECT("'Week " & ROW()&"'!A1")

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andrew Stephen" <[email protected]> wrote in message news:[email protected]...
> Hi
>
> I am not sure I am go to explain this correctly, but I will try my best.
>
> I have a workbook with a number of worksheets called week 1, week 2 up to week 52.
>
> I then have a summary sheet that is used to summarise data from the various weeks. In the summary worksheet I have a column
> listing the weeks
>
> ie
> B
> 5 Week 1
> 6 Week 2
> 7 Week 3
> etc
>
> and what I would like to do is use the name of the week to link to the worksheets rather then using say ='Week 2'!T$27 as I have
> approx 50 cells that I summarise the day and would like to make adding of a new week a little easier.
>
> I hope I have explained this OK and appreciated any suggestions.
>
> Cheers
> Andrew
>