Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

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

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
agwalsh
Asked:
agwalsh
  • 2
1 Solution
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
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
 
agwalshAuthor Commented:
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
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Thanks for the feedback. :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now