Forum

vba code to update ...
 
Notifications
Clear all

vba code to update pivot tables in another worksheet

2 Posts
2 Users
0 Reactions
67 Views
(@po0ja)
Posts: 1
New Member
Topic starter
 

Hi,

Could someone help me with the macro code? I want to create a dashboard where user can select multiple values from pivot filters and those selected filters should be applied on the filters in other worksheets. Here the data will be coming from a live source(Database).

 
Posted : 16/04/2019 12:55 pm
(@sunnykow)
Posts: 1417
Noble Member
 

Why don't you use slicer to filter the PT. 

You can refer here for more details on slicer.

https://www.myonlinetraininghub.com/slicer-controlled-interactive-excel-charts  

There are many more articles on MOTH's blog on this subject.

 
Posted : 17/04/2019 11:07 pm
Share: