Sorting after applying data validation

L

Leigh C.

Hi, everyone.

I'm working with a spreadsheet that has about 2,300 records, each of which
falls into one of five actions (phone call, meeting, email, mailing or
other). For each record, a specific description needs to be selected - and
this is dependent upon the type of action.
When I sort by action type and create a drop down list using data
validation, it works. All the e-mail actions are given three choices of
description from which to choose, all the phone calls are given four
different choices, etc.
The problem comes in when I sort the list by another value (last name, for
example). All the data validation entries (lists to choose from) stay locked
to their original position instead of moving with the row.
Does anyone have any idea what I can do about this to get them to all move
together?
OR, is there a formula that I can write that results in a conditional
drop-down? Ex: If C2=Phonecall, choose one of the following values, if
C2=Email, choose one of the following values, etc?
Sorry this is so muddled. Any help will be greatly appreciated!!!
 

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

Top