I am trying to figure out a way to filter out all string data that ends with a number in my pivot table using vba.
In my workbook, I created a macro "Create Pivot Tables Button" to create 3 pivot tables with 3 different results. I just want to concentrate on the sheet that will be called "personal" after running the macro.
The only way I found at the moment is using an array. The problem with the array is when the data changes, I might get new VehcName that are not in the array.
The vba code for the array I am using right now is found at the end of the coding as private sub PivotFilterTest.