Pivot table drop downs

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Drop Downs 3
how do I control the sort order of a filter in a pivot table? 1
pivot table - drop down filter box has 10% of items out of order 2
Pivot Table Refresh? 1
Pivot table drop downs not refreshing 1
sorting data in pivot table field drop downs 2
Pivot Table Items 3
Pivot Table field drop-down not refreshing 1

Top