Excel Gantt Chart Drop Down Menus
I am creating a Gantt chart that will encompass all of the marketing activities for my org. My goal is to create a central dashboard that can toggle in between subjects and populate cells based on which topic I have selected. The problem I’m having currently is trying to create a system where the dashboard populates based on what is selected in the drop-down menu (column B). I’ve explored implementing an x lookup system, but also looking for a simpler method.