Hi

This one has been stumbling me for a while

I have a list of data that can change in size and names etc, i want to use the info on this list to filtera pivot table using a macro. All the filtering will be done on the same field in the pivot table.

I know i can use slicers but they are not to suitable for what i am doing.

any help greatly recieved