Can you lock a drop-down cell so that it sorts with the row?

L

Lisa in Victoria

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

Gord Dibben

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
 

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

Drop down list control value in vba 2
Print Macro w/drop down list 1
Move Drop Down List to the Top of the Cell 0
Using a drop-down box to sort data based on seperate columns 2
How do I designate dates using info from a cooresponding drop down list? 3
Drop Down List Contains the List Header Row 1
Change drop down list in one cell based on values in other cells 2
Need a drop-down field that automatically sorts ascending 2

Top