I have a workbook with about 50 sheets of different country data with cells organized in identically in each sheet. I am attempting to use a combobox to select a country so you can get a snapshot on the dashboard. I am aware on how to build a similar dashboard when all the data is on one sheet, using combobox selection and index function. Do you guys have any advice for accomplishing this with multiple sheets?
Thanks,
Mike
Bookmarks