My case is the following :
I need to create a dashboard (as some of you have understood) in a workbook. On the first sheet, I replicate all the KPIs coming from the different queries I inserted in the sheet2, sheet3... by making a cell reference to the result I want to "import" in my dashboard.
But, on the dashboard, I oblige the user to choose a country and a month. The last one is usefull to define the last period I need to come back in the past (eg., when the user put june 2005, he will have on the dashboard screen "june, may, april, march...".
How can I create this pop-up in the dashboard?
How can I make this pre-selection valid for all the queries of the workbook?
Thanks a lot.