agwalsh
asked on
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
indirect_cell_reference.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the feedback. :)
ASKER