I have a workbook that has multiple country tabs (each country has its own tab) and within each country tab, data by day. I'd like to create a dashboard that has a dropdown to select the country and another dropdown to select the day, and have the dashboard populate with the appropriate country/day's data. I've created both the country and date dropdowns in the dashboard, but am having trouble creating the correct formula to pull the corresponding data. Any suggestions would be great, either for how to do this, or a better way to approach the dashboard itself.
Bookmarks