Specifiying the worksheet name in a cell

  • Thread starter Thread starter adiss
  • Start date Start date
A

adiss

I have several different xls with multiple worksheets in each I have
written the report that generates the data but I must manually go into
each field and change the worksheet reference each time the sheet
changes.

Could I have an additional colum which specifies which sheet to pull
data from? Then in each function sepecifiying how to create the value
needed the worksheet referance updates too.

Let me know if I need to clarify.
 
You can use

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

which pulls the value in H10 from the sheet specified in A1.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
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

Assigning a Worksheet Name to a Cell 4
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Spreadsheet summary automatically referrences totals of worksheets 2
Reference the same cell based on tab name 1
worksheet name variable external data cell 2
Linking to other worksheets 3
Absolute References and worksheets 0
USe Contents of cell as name of worksheet in a function 5

Back
Top