VBA to Update Pivot Table

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
 
P

paul.robinson

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

How I can set dynamic pivot table ONLY when I have enough data point 1
VBA Pivot Table Error 1
Linest, Pivot Tables, and VBA 2
Playing back a Pivot Table macros 2
Using VBA to create charts 1
Wanted to show 12 month Date in Pivot table 2
Create a Pivot Table with VBA HelP 4
Excel VBA For excel 0

Top