I have a Google Sheet with three tabs:
We use the schedule sheet to create meeting role assignments (data validated based on members sheet). We want to then use a pull down to choose an applicable date (see C1 in the Agenda sheet) and then have that populate the agenda sheet for the meeting specified by that chosen meeting date.
Here is a copy of the spreadsheet - Copy of Meeting and Agenda Planner.xlsx
Trying to find the right function in the agenda list so that the right meeting roles and meeting agenda appear in Column C (Agenda Sheet) based the date selected.
In the future, new meetings will be scheduled creating new columns to the right of those already in the Schedule tab
Trying to find the best way to do this but struggling.
So grateful for any guru help