Basically , I have created a pivot table in a new worksheet .
But I dont have any idea to create a data filter of the pivot table in vba code ?
I want to filter all data with the value(Count of Last Name) = 1
Based on macro recorder for fitler data:
Here's my code for Create Pivot Table:
Attachment 407580
This what will happens , after filtering the data to be "1"
Then , I would like to make the "Row Labels" or "Name" to be same
regardless if the name has spacing or capital letters. Just want to make it the same. How do i do this too ?
Please help
Bookmarks