Home Page Knowledge Base Support Forum Free Downloads

Simple Dashboard

Comparte tus hojas de cálculo salpicadero con otros usuarios aquí.

Moderator: DashboardWidgets

Simple Dashboard

Postby Jenny » Tue May 31, 2011 12:10 pm

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
Jenny
 
Posts: 0
Joined: Tue May 31, 2011 12:09 pm

Re: Simple Dashboard

Postby DashboardWidgets » Tue May 31, 2011 12:13 pm

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.

Dashboard for Jen.xlsx
(11.5 KiB) Downloaded 545 times

Simple Dashboard.jpg

Hope this helps.

Cheers

JaneF
http://www.ExcelDashboardWidgets.org
DashboardWidgets
 
Posts: 332
Joined: Mon May 30, 2011 7:06 pm


Return to 3. Comparte tus hojas de cálculo



Who is online

Users browsing this forum: No registered users and 1 guest