Pivot table drop downs

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
pivot table - drop down filter box has 10% of items out of order 2
Filtered drop down list 2
Pivot Table Help 1
Pivot Table Items 3
how do I control the sort order of a filter in a pivot table? 1
Excel Pivot Table - Sort Report Filter Values 3
Pivot table drop downs not refreshing 1

Back
Top