Dashboard hlp

jonespandrew

New member
Joined
Jan 27, 2016
Messages
122
Reaction score
0
Points
0
Hi there can anyone help with the followng or point me in the direction of video tutorials on how to do the following.

I have the attached speadsheet with two/ three

One is Data Tab, the othe Sum Tab and the other is call fillter tab.

On the Sum tab i have 3 data validation drop downs

1 called site, that selects form a list of sites.
2. called filter
3 prioirty

Then the headers of what data i want to populate.

What I want to happen is when the use selects a site and selects the filter that they want the table underneath then gets populate with the relevent data from the main data tab.

When no data is slected the table remains blank.

but want the layout somethink like on the last sheet

how can this be done.
 

Attachments

  • test.zip
    700.7 KB · Views: 20
Back
Top