VBA to Update Pivot Table
 

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

VBA to Update Pivot Table
 

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

On Jul 15, 3:32*pm, BGW wrote:
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