Trying to create a macro to filter out any string data with numbers in my pivot table

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!