Hi Tony
That isn't as easy as it might sound.
However, here's code that comes somewhat close to what you want to do.
http://www.contextures.com/xlPivot04.html
In any case, it already gives you most of the objects you need.
I don't know if it could be tweaked to sort, but you might give it a try.
--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music
"Tony" wrote:
When setting up a pivot table i have a field 'names' which I have placed in
the 'Drop Page Fields Here' so that I can print the rest of the table for
each individual. However when I select the drop down it offers me all the
names in random order. This would be ok with up to 10 names but is very time
consuming when there re a couple of hudred names.
Is it possible to put the drop downinto alphabetical order?
--
Tony