Need to have multiple worksheets use a single worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to have multiple worksheets use a single worksheet to do
calculations.the calculation worksheets needs to get info from the indivdual
worksheets. can you use varables in the formulas. ex ='WEEK 1'!B3 can you use
a varible for 'WEEK 1'!
 
Check in the help file for info on the INDIRECT() function

If you put "Week 1" in cell A1, your formula would read

=INDIRECT("'"&a1&"'!B3")

PS - If you change your tab/sheet names so that there are no spaces - Week1
or Week_1, as examples - you can dispense with the single quotes around the
sheet name
 
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

Worksheet Names using Macros 5
Linking Totals Across Multiple Worksheets 2
Multiple Worksheet in Excell Workbook 1
How do I find like data in multiple worksheets? 1
Counting multiple memberships 1
need help on either doing a loop and counting specific values orusing subtotal function 2
Using Worksheet Name 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top