Hi All
I have a couple of Pivot Tables that I create each month summarising my Income and Expenditure. The only problem I have is making the columns appear in the correct order, i.e. where July is month1 through June(the following year) being month 12 to coincide with my financial year. Oddly enough last month (January) was fine, following December. This month January and February appear in columns 1 & 2.
Anybody got any suggestions
Thanks
Robert
Re: Pivot Table Columns In Month Order
Howdy. Are you creating the Pivot Table new every month? If not, you can move the month to the correct position. Also, do you have the full date (i.e. 2/1/2007 for Feb - US format), or just the name (Feb)?
Re: Pivot Table Columns In Month Order
Hi Shades
Its all done new each month with a macro which imports data from my accounts package. This data has a date in dd/mm/yyyy format, which the macro converts to Month, and it is this that is the column heading.
Robert
Re: Pivot Table Columns In Month Order
My suggestion is to change the macro to change the order of the columns first in the pivot table before making the pivot table. If you have the book VBA and Macros for MS Excel by Bill Jelen and Tracy Syrstad, chapter 12 has excellent advice about code for Pivots and several examples.
Re: Pivot Table Columns In Month Order
Hi Rich
thanks for that, I don't have the book you mention but it sounds worth a try.
I eventually, this morning, solved the problem by creating a custom list of the month sin the order I needed and added a bit to the macro which sort sthe columns according to the custom list.
Thanks again for your help
Regards
Robert
Don’t have an account yet? Register yourself now and be a part of our community!
