Cell entry to access Worksheet

  • Thread starter Thread starter Roberto
  • Start date Start date
R

Roberto

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
 
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








- Show quoted text -
Click to expand...

Thanks Elkar this has worked a treat.

Many thanks

Roberto
 
Back
Top