using text in a cell as part of a reference

  • Thread starter Thread starter lsu-i-like
  • Start date Start date
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.:
 
=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...
 
thank you both sooooooooooooo much. ive been doing this by hand for
years. yay!:eek: :)
 
You must log in or register to reply here.

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

Duplicate Words in a Cell 2
Code to format cells on several worksheets 2
Creating A List of Items Between Two Numbers 2
Ref Formula 4
Using cell as worksheet reference (macro) 1
Use cell contents to build sheet reference 5
Ref Formula Query 1
Use worksheet name in one cell as part of reference in other cells 3

Back
Top