Dashboard supply

[chickadeejen]

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

 

[Shrikant]

more clarification please.
I think what u want to do is possible with formula.
try data validation and Vlookup.

I hope I've understand ur question !!

 

[Akashwani]

Hi Jen,

Take a look here for some Dashboard ideas.....

http://chandoo.org/wp/excel-dashboards/

Is this something like you have?...

Excel Workbook
	A	B	C	D	E
1	Name	Data1	Data2	Data3	Data4
2	Bill	Cat	Plane	100	500
3	Bob	Dog	bus	125	250
4	Tom	Fish	car	150	1,000
5	Tim	Panda	boat	100	750
6	Jim	Cow	bike	250	800
7	Jo	Bull	trike	125	200
8	Joe	Rabbit	Tut Tut	100	150
9	Sam	bird	Van	250	1,100
Tab1

Excel Workbook
	A	B	C	D	E	F
1	*	Name	Data1	Data2	Data3	Data4
2	1	Bob	Dog	bus	125	250
Tab2

The name in B2 is selected by using Data Validation.

Good luck.

Ak

 

[chickadeejen]

Ah funny...I was just looking at Chandoo site.

Yes, that could work. I'm trying it now!

Thank you!
Jen

 

[JaneF]

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.

http://www.exceldashboardwidgets.com/files/Dashboard for Jen.xlsx

Hope this helps.

Cheers

JaneF
www.ExcelDashboardWidgets.org

 

[chickadeejen]

Thank you - It works well