[mwitcomb]

Hi
We have a pivot table (see attached file)

What we need to do is we have multiple branch names associated with Team names, so when we click on a branch name in the dropdown, we only want to see the associated team names.

Currently when we click on a branch name all teams are displayed.

We then display the data.

For example, Newcastle branch has the following teams associated: Casualty, Casualty 1, Casualty 2. Birmingham has Casualty Midlands, Casualty Southern. When we click on Birmingham, all of the teams appear, we only want those to appear that are associated with that branch.

Hope that all makes sense!

Can this be done?

[georgev]

Your attachment appears corrupted...

Can you tell me what language / software product you are using?

[mwitcomb]

its a simple Excel spreadsheet
I`ve only zipped it up. Should open OK. Just tried it on my local machine.

[georgev]

Moved to Excel topic