Help on VBA - change pivot filter fields

[FixandFoxi]

Hi!

I am using the following VBA to transfer the pivot filters to other tables. This code is designed to handle/transfer one single pivot filter field, but I need 3 fields.

I have another VBA which changes all fields but due to performance issues not an option. Slicers are not an option as well.

How can I amend this VBA to handle 3 fields?

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Please edit your code to use code tags so that we can get started.

[FixandFoxi]

Ok done (sorry)...

[xlnitwit]

Thank you. Perhaps something like this

Please Login or Register  to view this content.

[FixandFoxi]

Works fantastic, thank you very much!