murman01
New member
- Joined
- May 14, 2015
- Messages
- 4
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2016
I've created a datasheet from which a pivot table will draw from. The datasheet will have rows added or deleted monthly. In creating the pivot table, my data source has been defined as A8:AY400; however, currently only cells A8:AY210 are populated. I picked 400 rows as I don't know how to get the pivot table to only report on the rows that have data in them, knowing that the number of rows in the datasheet is dynamic each month. Column A contains the name of salespeople. Cell A4000 has "END" in it so that my VBA code knows where the last row is when macros are run. The problem is when the pivot table displays the dropdown list from the report filter, both "END" and "(blank)" are options along with the names of the salespeople. The user can pick and choose which sales people the report will be generated for, but when the user chooses the "(select all)" option from the filter list, the pivot table reports on "END" and "(blank)" too. How do I get this to stop happening? Do I need to create some sort of VBA code that hides the dropdown list generated by the filter list and then create a fake dropdown list that the pivot table will use as a filter for generating the report OR is there some sort of option within the pivot table I can set? Thanks!