Using a combo box on multiple pivot tables

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

Guest

I am using a combo box to select data that will update a field on several
pivot tables to keep them synconized. ie one tabel is Month and the other is
Year data. What happened is I have history in the Year data for an item and
no data in the Month data. How can I return data in the Year table and a
message in the Month table that there is no data available?
 
Here is the code I'm using:

Sub SynchPCK_CAT()
'
' SynchPKG_CAT Macro
' Macro recorded 4/25/2006 by Rick Tipton
'


ActiveSheet.PivotTables("PivotTable5").PivotFields("PKG_CAT").CurrentPage = _
ActiveSheet.Range("D201").Value

ActiveSheet.PivotTables("PivotTable6").PivotFields("PKG_CAT").CurrentPage = _
ActiveSheet.Range("D201").Value

ActiveSheet.PivotTables("PivotTable7").PivotFields("PKG_CAT").CurrentPage = _
ActiveSheet.Range("D201").Value

ActiveSheet.PivotTables("PivotTable8").PivotFields("PKG_CAT").CurrentPage = _
ActiveSheet.Range("D201").Value
RptFormat
HideEmptyRows
End Sub
 
You must log in or register to reply here.

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

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Using VBA on Excel Pivot Tables 3
Expand and collapse 2
Passing Criteria to a Pivot Table from combo boxes 3
Pivot Table Question 2
Pivot table multiple filters 2
Link Drop Down list with Pivot Table 3

Back
Top