I have an Inventory report that uses the "Sheets" option, creating a new sheet for each inventory group.
I need to have a summary page that pickes up each sub-total adds them all together and produces a total inventory number.
I know that the sheets will be renamed to the default dimensions, but until the sheet is created, I am uncertain how to refer the formula to look at it.
EG I have inventory with dimensions 1000, 2000 and 3000
I have created a sheets cell, using this field from default dimensions.
On that sheet, I have a sub-total of Finished Goods and a sub-total of Raw Materials.
I also have a summary sheet.
I need the summary sheet to look up the sub-total of raw materials and finished goods for each sheet created.
The number of rows will differ depending on whether certain items have inventory or not.
If this possible, please?
Thanks and regards
Simon
Date
Votes
4 comments
-
Jet Reports Historic Posts I would love to have an answer to this one.
A programmer did one of our sheets that attempts this but it is not working.
It uses INDIRECT(ADDRESS(…))
Does that sound familiar to anyone?
Susan -
Jet Reports Historic Posts Here are a couple of different examples of how to do this. I would recommend trying example 2 since it is easier, but if you want to use the INDIRECT(), use the first one. Let me know if this is useful or not!
-
Jet Reports Historic Posts Hi guys,
I have used a Startsheet and an Endsheet to do the same thing which I think works fairly well and much easier than using INDIRECT.
You just need to add a formula on the summary sheet that will sum the all the values across all sheets between startsheet and endsheet for that cell reference.
Check the example attachment.
The only thing is that it does not seem to hide the start and end sheets with the AUTO+HIDESHEET in A1.
Open to suggestions, comments… -
Jet Reports Historic Posts Hi Meemz,
Thank you for sharing this tip! So simple if you look at that, and yet it's a trick I'd not seen before.
About the HideSheet… it only works if there is any Jet Reports function on the sheet. So if you enter a dummy function (e.g. =NP("Eval","=NOW()") ) in Cell B2 on both your StartSheet and EndSheet, the HideSheet will be triggered and executed.
Thanks again for learning us a new trick.
Please sign in to leave a comment.