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