Vba for pivot

bkeat

New Member
Joined
Jan 2, 2013
Messages
20
Hi,


I would like some advice on a pivot i must create each month for consolidating orders from a flat file in excel. Attached is an example.


Sheet 1: Orders FLAT FILE
Sheet 2: PIVOT
Sheet 3: Master


Once i get the pivot fixed (or possibly an alternative to a pivot as the flat file could have more lines each month)
1) Issue with the pivot at the moment is I can't get the months to sort (jan,Feb, Mar... and so on) they now sort alphabetically (Apr, Aug, Dec...)
2) Secondly once i have the pivot i want to be able to match the month from the column heading to a master sheet through vba (Example in the attached file) matching the Item Code to the month. ( the month will be rolling in the master each month.
a) Reason i use the pivot is to sum the orders if there is more than one order for an item in a particular month.


Hope you help or advise?


Thanks.

I can't attach a file to show, any suggestions ?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top