I have a pivot table on sheet named Schedule2. I need to filter out column D based on a criteria on sheet named "Criteria" in column A2:A220. I have a VBA code but i get an error "advancedfilter method of range class failed". funny thing is that this VBA will work on other machines but not all...