+ Reply to Thread
Results 1 to 4 of 4

Excel Table - Creating a Grocery List

  1. #1
    Registered User
    Join Date
    05-20-2022
    Location
    California
    MS-Off Ver
    365
    Posts
    5

    Excel Table - Creating a Grocery List

    Hello, I have several recipes stored, along with the ingredients for them in a spreadsheet. My goal is to have one long list (in a column) of all my recipes with a dropdown menu. From there, I would select say 5 recipes for dinner that week. What I would like to see happen is once I select the meals I want, the ingredients will populate in a list somewhere.


    I have attached my spreadsheet and you will see I have tried some testing. Sheet1 was my first attempt. Sheet2 is more what I want, however when I select the drop down dinner selection, it only shows the first ingredient. I know I could list the Ingredients in rows, but I'd like the list to populate in a column so I can print it out, cross out what I have, and go shopping.

    If you need more information, please let me know.

    Apologies if this is the wrong section of the forum - I am new here


    Grocery List.xlsx

  2. #2
    Registered User
    Join Date
    05-20-2022
    Location
    California
    MS-Off Ver
    365
    Posts
    5

    Re: Excel Table - Creating a Grocery List

    Any advice?

  3. #3
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    6,986

    Re: Excel Table - Creating a Grocery List

    I haven't looked at your project file .... but, there are several example projects on this and other forums that accomplish your stated goal.

    Have you made a search for those example files / form postings to see if the information there can assist you ?

  4. #4
    Registered User
    Join Date
    05-20-2022
    Location
    California
    MS-Off Ver
    365
    Posts
    5

    Re: Excel Table - Creating a Grocery List

    Yes I went through all related articles and watched a couple videos on it. It's not clicking with me

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with grocery list generator
    By allenayres83 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 10-25-2022, 09:12 PM
  2. [SOLVED] Quanity calulator for grocery list
    By rose8693 in forum Excel General
    Replies: 6
    Last Post: 11-14-2019, 05:56 PM
  3. Complete Newbie Here, Grocery List Help
    By CassieBurt in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-21-2016, 11:59 AM
  4. Grocery list
    By jammerculture in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2015, 04:22 PM
  5. [SOLVED] Creating a grocery list in a new worksheet based on selected items in a master list
    By jacolli4 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2012, 07:53 AM
  6. [SOLVED] Grocery List with Price comparison
    By mrJack808 in forum Excel General
    Replies: 8
    Last Post: 04-04-2012, 10:57 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1