Prev: Pivot Table Values as a % of a Subtotal
Next: Pivot Chart to MSWord?
From: Lisa in Victoria Lisa in on 26 Jan 2010 16:19
I have created drop-down cells (type of business) for my client contact list
but when I sort that list alphabetically or by last contacted date the
drop-down cells don't sort with it. How can I solve that issue?

Thanks for the responses!

From: Gord Dibben on 26 Jan 2010 17:47
Are these Data Validation dropdown lists?

Where is the list range located?

i.e. =$A$2:$A$20

If inside your sort area the lists should change to whatever is in A2:A20
after the sort.

Tested in 2003 and 2007


Gord Dibben MS Excel MVP

On Tue, 26 Jan 2010 13:19:01 -0800, Lisa in Victoria <Lisa in
Victoria(a)discussions.microsoft.com> wrote:

>I have created drop-down cells (type of business) for my client contact list
>but when I sort that list alphabetically or by last contacted date the
>drop-down cells don't sort with it. How can I solve that issue?
>
>Thanks for the responses!

 | 
Pages: 1
Prev: Pivot Table Values as a % of a Subtotal
Next: Pivot Chart to MSWord?