How to Pass >1 element into a Page Filter of a Pivot Table using VBA through a ListBox

[e4excel]

Dear Forum,

I am creating a Pivot Table for my office report, I am working on the Performance Report and need to prepare the YTD Performance Report beginning from Apr-18 till Jul-18.
I need to make 4 separate reports i.e. Apr-18, Apr-18 and May-18, Apr-18, May-18 and Jun-18, Apr-18, May-18, Jun-18 and Jul-18.

Now I have a column in YTD Data where I have these months, I have also managed to create a Unique List but I don't know to pass these elements into the Page Filter using VBA as shown above.

I need help to create a list box where I can store and then select them at Run-Time and then pass it on to the Pivot Table.

Can someone please help me with the code..

Please Login or Register  to view this content.

Due to the sensitive nature of the data I cannot share the file immediately...


Thanks in advance

Regards
e4excel

[e4excel]

Please can someone help me on this portion...I need to do a lot of such YTDS for several different Roles...SO any help would be greatly appreciated...

[e4excel]

Bumping this thread