Hi,
I have a pivot table that I work on everyday. I pull in a few different fields.
One of the fields that I use is called Campaign Name. Each day I have to manually choose from 20 campaigns that I want to see, out of a list of over 1000.
Is there a way where I have the campaign name on another sheet and have a macro that detects the names on that range and filter the pivot table for me?
Thanks
I have a pivot table that I work on everyday. I pull in a few different fields.
One of the fields that I use is called Campaign Name. Each day I have to manually choose from 20 campaigns that I want to see, out of a list of over 1000.
Is there a way where I have the campaign name on another sheet and have a macro that detects the names on that range and filter the pivot table for me?
Thanks