- Thu Jul 31, 2014 9:57 pm
#146
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
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