ExcelDashboardWidgets

Hi,

I'm trying to do something fancy, but it's way beyond me knowledge of excel

Layout:
Tab 1 - Data source (project info) from a query (freshable, thank goodness)
Tab 2 - Dashboard required. At the top, I've inserted a Format Control box which lists managers names. The object is to be able to click on the name eg. John Smith (within the Format Control box) and the project detail will appear against his/hers name.

Here's the tricky bit....

I have 4 static fields below the format box:

Inflight
Completed
Up & Coming
Cancelled

When someone selects a managers name from the Format Box....I want the data to appear (which is sourced from the data tab) to find it's static field and appear under either Inflight, cancelled etc.

I don't know if this can be done by a formula or VB.

Any solutions?
Thanks,
Jen

Jen

This can be done very simply without the need for macros or visual basic.

I've played around and have prepared a spreadsheet that you can download here.
Hope this helps.

Cheers

JaneF
http://www.ExcelDashboardWidgets.com