Can a formula capture the Grand Total - Volume as it increases daily. The grand Total - Volume will be visible in MAIN!C12
Is there anyway of using the GROUPING in the 3 sheets without unprotecting the sheets.The GROUPING can only be used if the sheet is unprotected
Thanks
Paul
Use this
=INDEX(INDIRECT("'"&G5&"'!$D$4:$D$53"),MATCH("Gran d Total",INDIRECT("'"&G5&"'!$B$4:$B$53"),0))
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
For the grouping issue, here's the apt solution
http://www.excelfox.com/forum/f12/en...worksheet-874/
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks Excel Fox for both formula and code
The Indirect Function looks to be a very useful one.
How does this formula work especially the Indirect part.
Is this part referring to a sheet "'" ??Code:(INDIRECT("'"&G5&"'!$D$4:$D$53")
How does it know which sheet or can the sheet name also be placed in the formula?
Thank you
Paul
Posting Permissions
Reply With Quote
Bookmarks