Hi All,

I have a number of spreadsheet that use the same data. What I want to
be able to do is to enter a year in e.g. cell B4, this will also be
the same as a worksheet, and use this cell to reference a worksheet in
a formula.

Sorry if this does not make complete sense, but if need I will try and
explain more clearly

Roberto

Use the INDIRECT function. Something like:

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

This will reference Cell A1 on the Sheet whose name is stored in cell B4.
Note the use of double and single quotes, shown here with additional spaces
(do not include the spaces): " ' " & B4 & " ' !

HTH,
Elkar


"Roberto" wrote:

Hi All,

I have a number of spreadsheet that use the same data. What I want to
be able to do is to enter a year in e.g. cell B4, this will also be
the same as a worksheet, and use this cell to reference a worksheet in
a formula.

Sorry if this does not make complete sense, but if need I will try and
explain more clearly

Roberto

On 16 Jul, 23:38, Elkar wrote:
Use the INDIRECT function. Something like:

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

This will reference Cell A1 on the Sheet whose name is stored in cell B4.
Note the use of double and single quotes, shown here with additional spaces
(do not include the spaces): " ' " & B4 & " ' !

HTH,
Elkar



"Roberto" wrote:
Hi All,

I have a number of spreadsheet that use the same data. What I want to
be able to do is to enter a year in e.g. cell B4, this will also be
the same as a worksheet, and use this cell to reference a worksheet in
a formula.

Sorry if this does not make complete sense, but if need I will try and
explain more clearly

Roberto- Hide quoted text -

- Show quoted text -

Thanks Elkar this has worked a treat.

Many thanks

Roberto