I have searched the forum to locate how to add additional sort criteria to the dropdown "settings" in the sample download : Project-portfolio-dashboard-VBA-v1-2010.xlsm.
However, unable to locate.
Requesting assistance how to add.
I have had a look at your file. The real work happens on a sheet originally titled Sorting. I have added an additional item to the Drop Down called Spend. This I have highlighted in Yellow on the Sorting Tab. I have also highlighted the new column I added in Green. Formulas need to update as well in Cols L and M of that sheet but that will become apparent as you play around with it.
It is a very pretty and well designed layout but do you notice all the screen flicker? This is the file grinding under the pressure of all the named ranges, probably dynamic ones. As a working file I think it could be vastly improved as with so little information inside the file it should perform seamlessly. I am just going to stand back and throw rocks in a cowardly manner as it would take considerable time to clean it up.
Hello adragton, thanks for the assistance with this problem, I am a newby in excel and this is over my head. I found your example yesterday and was trying to figure it out looking at your spreadsheet that you posted until I got a headache and gave up. Is there any way that you can send me the actual excel file so I can take a closer look at it. Thanks for your assistance with my problem.
Since writing the application, I have gotten better, and changed techniques, especially the sort.
I now use a "Macro" from the sort dropdown to determine the text selected, the have the marco execute the sort.
It is "generic" therefore works for any selection.
It uses the columns from "Project Details" in Order:=xlAscending.
I am thinking of putting "radio button" next to sort with " Ascend/Descend".
to find the script-
1.go to Developer tab
The dropdown gets connected by:
1.Right click the dropdown
3.Doulde click "sort" (name of the script)
Where does the dropdown gets its data
2.Row 174 has the text
3.Right click dropdown
5.Input range - select from calculations rows 175-181
Hello adragton, thank you for your help with the project management spreadsheet. Now it sorts by almost all the fields available originally. I have a question, when you execute a search, it displays a message, once you click OK it does the sort. Do you know why it does that, and can it be removed?.
I know I am a pain in the ass, but I need to present this project dashboard to my boss next week and I am not getting any luck with the folks at chandoo, I wrote them several email messages about his topic and nothing.