I'm creating a grocery list in excel and I am struggling with one big part of it.
- Page 1 is dedicated to meal planning, page 2 is an ingredient check off with the associated grocery store and a need/have column based off home inventory. Page 3 is the grocery list sorted by store.
- I am trying to get all of the "Need" items from page 2 on page 3, but sorting them by grocery store. So three different columns on page 3 (Aldi, Walmart, Costco).
- Page 3: Aldi Column criteria (Must be marked as "Need" and "Aldi" on page 2
Walmart Column criteria (Must be marked as "Need" and "Walmart" on page 2
Costco Column criteria (Must be marked as "Need" and "Costco on page 2
Is that possible?
Transferring data from page to page and automatically sorting