Transferring data from page to page and automatically sorting [Closed]

Report
-
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?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!