FWLIW, here's a sample construct (steps described in my response to you in
the other branch) which delivers exactly (imo) what you stated you wanted in
your orig. post:
http://www.savefile.com/files/6699697
SortByDayAscending_ByMonthDescending_PivotTable
_vbastarter_misc.xls

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--