Please tell me there is a way!

S

Sparky13

There must be a way.
I need to type the Worksheet (Tab) name in cell A1 of Worksheet "A" and
have the data from a specific cell in that Worksheet (B,C,D whatever)
returned to B1 of Worksheet "A". All the Worksheets are in the same Workbook.
The tab names will be differant, and many, depending on the Workbook and
Worksheet "A" will be copied to many Workbooks.
 
S

Sloth

=INDIRECT(A1&"!B1")

If the sheet name contains spaces you will have to use this formula

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

A1 contains the sheet name, and B1 is the cell you are referencing.
 
S

Sparky13

Yes Yes Yes Exactly what I needed.
Thank You

Sloth said:
=INDIRECT(A1&"!B1")

If the sheet name contains spaces you will have to use this formula

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

A1 contains the sheet name, and B1 is the cell you are referencing.
Click to expand...
 
Top