Please tell me there is a way!

G

Guest

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

Guest

=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.
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Creating A List of Items Between Two Numbers 2
Ref Formula Query 1
Setting Scope of name ranges to particular worksheet 2
Freeze Formulas - Replace Worksheet 5
Copy/Paste Question 3
Hyperlink via indirect cell reference 8
Link behavior with changing data set 3

Top