Skip to Content
Former Member
Oct 17, 2005 at 10:18 AM

Pop-up for refreshing different queries at the same runtime in a workbook


Hi gurus,

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.