Hello folks,
I'm querying information from my Sage CRM system into excel and creating a dashboard based on the sources the CRM info is from - exhibitions, seminars etc, as well as the progress of sales opportunities from each Source etc.
The problem is the list of sources the queries pull from - I can't code it into the queries as they will change over time and this is destined for users who cannot change it themselves, and I don't really want to have to change the sources in each query by filtering within the pivot table.
What I need, ideally, is a multiple choice List Format Control box with a dynamic range that controls all of the tables/charts on the sheet, but I don't seem to be able to apply a dynamic range to a Pivot table (may be wrong here).
Unfortunately I'll struggle to provide actual copies of data as my boss will have my scalp.
Cheers,
Seb
I'm querying information from my Sage CRM system into excel and creating a dashboard based on the sources the CRM info is from - exhibitions, seminars etc, as well as the progress of sales opportunities from each Source etc.
The problem is the list of sources the queries pull from - I can't code it into the queries as they will change over time and this is destined for users who cannot change it themselves, and I don't really want to have to change the sources in each query by filtering within the pivot table.
What I need, ideally, is a multiple choice List Format Control box with a dynamic range that controls all of the tables/charts on the sheet, but I don't seem to be able to apply a dynamic range to a Pivot table (may be wrong here).
Unfortunately I'll struggle to provide actual copies of data as my boss will have my scalp.
Cheers,
Seb