I have a report that I am trying to automate. It needs to create a pivot table, filter it, and generate a chart. The way I have it recorded, it is filtering by de-selecting certain usernames (which won't always be there). What I would rather it do is filter by selecting usernames according to a range on a separate worksheet. After searching through the forums, I have hacked together the code below:
However,
1) I am not sure that it is written correctly.
2) I don't believe I am inserting it correctly.
Sample workbook with filtering by de-selecting certain usernames is attached.
Bookmarks