December 15, 2022
I have written a recipe program that can scale recipes for a Meals on Wheels Charity I am volunteering for.
This question is about how to get data from each recipe page only create a summary page showing the - recipe name, sell price per portion, CoGS, and Gross Profit on the summary page instead of typing them individually. Many more recipes will be added in due course and the order of the Excell worksheet recipe change sometimes.
I am using a PC with Office 365
I am not sure if I can do this with formulae only or if I need VBA which I believe currently is the best solution.
I managed to learn how to create a table of contents with hyperlinks, but this is beyond my current skill level. I am also open to any suggestions to improve what I have done
the link is https://www.dropbox.com/scl/fi.....khf64wykar
I am not up to date with sharting files I hope this works
Thanking you in advance for your support and advice
October 17, 2018
Hi, took a quick look but your named ranges are inconsisten and need to be checked for incorrect references only then it can be done.
There is a large number of #REF and other pointing to an incorrect (non consistent) cell.
Once you get that done, then array formulas or similar can be used.