• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

How to create a summary page from data that is on the recipe pages only|VBA & Macros|Excel Forum|My Online Training Hub

You are here: Home / How to create a summary page from data that is on the recipe pages only|VBA & Macros|Excel Forum|My Online Training Hub

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope




Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_CrumbsHome HomeExcel ForumVBA & MacrosHow to create a summary page from d…
sp_PrintTopic sp_TopicIcon
How to create a summary page from data that is on the recipe pages only
Avatar
Henry Miszelowski

New Member
Members
Level 0
Forum Posts: 1
Member Since:
December 15, 2022
sp_UserOfflineSmall Offline
1
December 15, 2022 - 1:59 pm
sp_Permalink sp_Print sp_EditHistory

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

Henry

Avatar
Hans Hallebeek
the Netherlands
Member
Members
Level 0
Forum Posts: 32
Member Since:
October 17, 2018
sp_UserOfflineSmall Offline
2
December 15, 2022 - 5:32 pm
sp_Permalink sp_Print

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.

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 170
Currently Online:
Guest(s) 66
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1431
Anders Sehlstedt: 845
Velouria: 574
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 213
A.Maurizio: 202
Aye Mu: 201
Jessica Stewart: 185
Newest Members:
Vicky Otosnika
Abhishek Singh
Kevin Sojourner
Kara Weiss
And Woox
Armani Quenga
moshood bello
annelies b
James1989
lucy gilmour
Forum Stats:
Groups: 3
Forums: 24
Topics: 6045
Posts: 26523

 

Member Stats:
Guest Posters: 49
Members: 31492
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Riny van Eekelen
© Simple:Press —sp_Information
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x