VBA to Update Pivot Table

  • Thread starter Thread starter BGW
  • Start date Start date
B

BGW

Hi

Can someone help me with macro. I have a pivot table with 12 columns of
data(for the twelve months). A user will enter the month that he wants to
display in cell A1 and I need the pivot table to display that column plus the
two previous months and hide the others.

Thanks
 
Hi
Try the macro recorder while you do it manually. Should get you
started pretty well.
regards
Paul
 

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
Expand and collapse 2
Linest, Pivot Tables, and VBA 2
Wanted to show 12 month Date in Pivot table 2
VBA Pivot Table Error 1
Playing back a Pivot Table macros 2
Using VBA on Excel Pivot Tables 3

Back
Top