Hi everyone,
I'm trying to do a few things and I'll start off with the easy part of the two parts then jump into the second...
The first, I have a ton of data for specific projects listed in one tab, called ProjectData (Requirement #, Release Date, Owner, etc.). What I'm trying to do is have a Dashboard page where the owner of any of the projects can pick their team from the dropdown and in the cells below, the appropriate data from the first tab will be shown. What I have done is basically tricked Excel by saying =IF(ProjectData!ProjectTeamName=Dashboard!ProjectTeamDropDown, ProjectData!A1,"") and copy this formula across all the cells that I would like to return. When the user selects "Project #1", a lot of the cells returned are blank (only the ones with Project #1 show the correct data). This results in having to add Data->Filter to the data and the user selecting to Hide Blanks. Is there any way to accomplish what I'm trying to do without any necessary interaction from the user? Also, if the user selects a Project (Project #2), but they would like to return to seeing all Projects, I'm not sure how to accomplish this? Maybe some use with a Wildcard*?
The second part, I would like to add a few more dropdowns so the user can get deeper into the data by only touching dropdowns. So once Part 1 is accomplished, I'd like to add DropDowns for Release Date (Jan 2014, June 2015, etc.) and also Owner (John Doe, Jane Doe, etc.).
Essentially, a user could drill down to something like this... Project #1-Jan 2014-John Doe and return 3 results vs. the 300 for Project #1.
Hope that helps and if anyone would like to see an example, let me know and I can provide one. Thanks for the help in advance!
Bookmarks