Macro to control 2 pivot tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear Sirs,

There are 2 PVTs in one worksheet, they are PVT1 and PVT2. They are 2
exactly same PVT.
In page area, there are fields of shops, year.
In row area, there is month.
In column area, fields are categories and products.
When I choose different items in categories and products in PVT1, I need
PVT2 change as well. Can I do that? Can someone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make 2 Pivot Tables in same items 1
Macro Help!! 7
pivot table 1
Macro Debug on Pivot Table 5
sorting in pivot table 3
Pivot Table Calculated Field / Item 1
VBA Pivot Table Error 1
Create multiple Pivots based on list of parameters 4

Back
Top