I tried searching but couldn't find solution to this
i have pivot table that i use to refresh some data daily
i wonder if there is a way to filter the pivot table with vba based on a list with names in another sheet?
sheet1 is the pivot table
sheet2 is the list with the names
VBA code to check before each refresh and filter only the names listed in sheet2