Forum Discussion

ljj's avatar
ljj
Copper Contributor
Mar 18, 2025

Automated Grocery List

Hi,

 

I'm trying to build an automated grocery list where I have a table full of recipes and then another table where I can select meals for the week. 

Based on meal selection, i would like to populate a list of groceries using the recipe table.

 

My issue has been with getting this grocery table to work correctly, i'm not sure how to output results into another table that is dynamic. 

 

example of meal selection table

example of recipe table

 

I want to be able to have all my ingredients for selected meals summarized by category and total quantity 

  • Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources