Two-way drop down boxes

[VinceT]

Good morning awesome excellers,
I'm building two dashboards in one workbook. (Yes, I know I could split it, but all the source data is virtually identical, so I'm trying to minimize duplicate data and avoid inter-workbook links)

On the "dash" worksheet, I have a drop-down where the user can select a month to see all the sales stats for an individual for the given month. It is set up as a list with a named range "lstDashboardMonth" which points to another sheet with all the months.

On another worksheet "summary", I'm creating a summary of key metrics for all the sales people for a specified month, and a few YTD numbers as well. I'd like to put another drop-down box on this sheet, allowing the user to select a month. However, all the formulas on the "calcs" sheet look up data using the month specified on the "dash" worksheet.

So here's my question- outside of a VBA solution, is there a way to have drop-down boxes on two different sheets that can change each other? For example, if I select "March" on one sheet, can I have it change to "March" on the other sheet? That would enable me to keep all the formulas the same.

Thanks!
-Vince

 

[srinidhi]

Please upload the excel

 

[Faseeh]

Hi VinceT,

You can put drop down on the either of the sheet and simply connect the other one with the first one so if you change the month, rest will change. This will work as you want one sheet for one month and the other for YTD.