I'm trying to streamline a workbook so that all data is entered in one spot that then auto-populates several other sheets with filtered results, based on the criteria of lists that may change over time.
Using the example I attached:
- The user enters line items in the master. Type is selected from a drop-down list. That drop-down needs to populate from three separate lists on a different sheet.
- Then, depending on the type of a record, each record then populates three other 'result' sheets.
- Ideally, each 'result' sheet should update automatically as the user enters results on the Master sheet. Likewise, the Type drop-down list should be able to change as items are added to it.
I've included my example. Please feel free to ask me any questions if you think you can help:
Meal Schedule.xlsx
Bookmarks