Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How do I amend an indirect formula so I don't have to type the cell reference into another sheet?

Posted on 2016-11-04
3
Medium Priority
?
72 Views
Last Modified: 2016-11-04
I found Ashish Mathur's rather brilliant way to generate a list of worksheets. Now I want to use an indirect formula to reference a cell on each of these sheets without having to put the cell reference into the summary sheet. How do I do that? Am attaching what I have.
indirect_cell_reference.xlsx
0
Comment
Question by:agwalsh
  • 2
3 Comments
 
LVL 33

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 2000 total points
ID: 41873761
If you input the Sheet Name in B11 of Summary Sheet (which is currently empty), the following formula will return the Total of that Sheet.
=INDIRECT("'" & B11 & "'!C7")

Open in new window

0
 

Author Closing Comment

by:agwalsh
ID: 41873803
Experts Exchange comes through again...knew I was missing one small bit and got the answer I wanted in less than 30 minutes..brilliant!
0
 
LVL 33

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41873823
Thanks for the feedback. :)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question