This looks amazing. It does exactly what I want it to do. Here are a couple questions I have for you.
Data Entry Tab
Do you think I still need column E "Rank" on the "Data Entry" tab if you correlated the direction of the ranking in the list tab?
I added a new column to the List sheet to link the Category with the direction of sort. This is used by both the program and data entry sheet. Now when you select a category on the Data Entry sheet, the Rank is looked up and you do not have to enter it.
Dashboard 1 Tab
I would like to put all my pivots/charts on "one" dashboard tab to make it look nice, plus add some slicers. I added a buffer column to the "Dashboard 1" tab to incorporate these changes. The VB still worked. Would you suggest I changethe code from B24 to C24?
The code is in two parts:
Part one fires off the event when the value in cell B24 (Category Dropdown) on the Dashboard 1 page is changed. If you move the position of this cell, you will have to change the code.
Part two gets called when you change cell B2. It applies the sort to the pivot table on this page.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
Why is my slicer duplicating the month of January?
YTD Tab (Can't combine 2 pivots into one chart)
I would also like to show the scores of a Team in a Category YTD. I have accomplishes this, however, to take it one step further it would be nice to see what the team members scores for the year vs the average of scores for all the teams. I believe the only way to do this is to create another column in my data entry tab. with a formula
Bookmarks