excel and pivot order
 

1. Can I change the order of the columns before/after the creation of
the
pivot using VBABY order of columns I mean If I have Total Last Year,
Total This Year, Jan2006,Feb2006,...,June2006,July2006 as the columns
in pivot then can I make them to appear as
Jan2006,Feb2006,...,June2006,July2006 ,Total This Year,Total Last Year
If there is any confusion pl write me back , I will send you the exact
Pivot.
2. Also is it possible to remove some of the columns from Pivots?
I want to use VBA to do it.