refresh consolidated ranges pivot table

Hi Guys,

i am using code to refresh pivot table after changing data within table.

Please Login or Register  to view this content.

The goal of code is to refresh pivot table after every input into tables.
This is working ok and i am getting unique data validation lists which i can use in workbook.
You can test via inputting new data into Table1.

Problem is that i have 2 separate tables which i should consolidate.
I used PivotTable and PivotChart wizard to consolidate ranges from Table1 and Table2:

Screenshot_5.png

Problem is that after refreshing consolidated pivot is not updating data.

VBA is no working here:

Please Login or Register  to view this content.

i think that issue is because i can not provide dynamic range into pivot consolidation list.

How can i refresh consolidated pivot range?
Or maybe another method?

Best,
Jacek

Anyone?

Best Wishes,
Jacek Antek

bump,

Best wishes,
Jacek Antek

Hi Guys,

can anyone help ?

Best,
Jacek

Hi Guys,

answer is simple. You can refer to consolidated ranges as dynamic listobjects !
Ha !

I am closing the topic ;-)