Create 2 pivot table using macro

I want to ask, let's say i want to create 2 pivot table using macro, do i need to create it like this, the difference between 2 pivot table is only the filter.

But if i want to make for 5 filter, then i think the code is too long, can anyone help to simplify this code. i'm new to VBA Excel, thanks in advanced

Please Login or Register  to view this content.

Bump No Response

Bump No Response

"do really i need to always do dim every pivot, please help anyone that can make this code simple"

Please Login or Register  to view this content.