On May 19, 12:01 pm, "Bob Phillips" wrote:
You only have to enter the list once. DV has to be better as the user then
cannot make a mistake, if they have to type it in they could type anything.
I certainly wouldn't want to have to enter it.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Sean" wrote in message

oups.com...



I wish to create a Data Validation Dependent Lists if a certain Value
appears in a Cell (say A1). I have looked at Contextures and it
explains it, but what if the value selected in my cell (A1) is =
London, then I want the user to type the appropriate values into the
'Data Validation cell' instead of from a dependent list selection. If
the value selected in A1 = Paris, then I wish the dependent list to
kick in.

The reason I ask is if London is selected, product codes (i.e. the
dependent lists) run to 100's, if Paris is selected I have only 4
product codes, so I would let the user enter for London but for Paris
they would select from only 4. Just makes things easier for me than
maintaining a dynamic list of 100's

Thanks- Hide quoted text -

- Show quoted text -

Thanks Bob, not quite, products are added and deleted from one
particular list and I've 20 users working on the file at remote level,
so I couldn't physically maintain it, thus I thought if they could
manually type for one location and use drop downs for the other
(smaller) locations