• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

List Format Control Box with dynamic range controlling multiple pivot tables/charts

Seb

New Member
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
 
Hi, Seb!

As a new user you might want to (I'd say should and must) read this:
http://chandoo.org/forum/forums/new-users-please-start-here.14/

And regarding your issue, consider uploading a sample file (including manual examples of desired output if applicable), it'd be very useful for those who read this and might be able to help you, relieving the contributor of having to build a test file, if necessary. Thank you.

Regards!
 
Back
Top