using text in a cell as part of a reference

L

lsu-i-like

i have an excel file with 119 worksheets.
each worksheet has a certain name.

worksheet 50 is named "dogs"
on worksheet 1 in cell A1 is the text "dogs"
on worksheet 1 i want cell B1 to =dogs!j20.

is there a way i can automate this by making B1 =(text in A1)!j20?

an answer to this would save me so much time and i would be ever s
happy.:
 
G

Greg

=INDIRECT(A1 & "!J20")


lsu-i-like said:
i have an excel file with 119 worksheets.
each worksheet has a certain name.

worksheet 50 is named "dogs"
on worksheet 1 in cell A1 is the text "dogs"
on worksheet 1 i want cell B1 to =dogs!j20.

is there a way i can automate this by making B1 =(text in A1)!j20?

an answer to this would save me so much time and i would be ever so
happy.:)
Click to expand...
 
Top