Hi,

I know my title is a bit vague but I couldn't really think of how to describe what I require.

Basically I have lots of data that I have built multiple pivot tables/charts for. I want to be able to have one primary front page that will show my charts that show overall totals but then I want to be able to have a single drop down list which users can select a user from. Say they select "John", then all pivot tables/charts related to John will be shown and if they then select the next user "Mary" then all the data will change to Mary's data (the pivots/charts are all the same). I just can;t think of the best way to get started on developing something like this.

Hope that makes sense,

Thanks for any help,

Daryl.