Prev: Look up table?
Next: calculate hours
From: SNA400 on 1 Mar 2010 15:44
My original problem is listedbelow

I am using Data Validation for selected vehicles on runs, but I need to stop
people assigning a duplicate registration for seperate runs.
The list for the data validation is in cells D91 to D120 and the entries are
made in cells H3 to H47

ALSO - on the same sheet I need to stop people using the vehicle
Registrations from the validation in cells H48 to H60 - can I use the same
validation list or do I have to set it up again

I have used all the info from http://www.contextures.com/xlDataVal03.html to
sucessfully create a dropdown that doesn't show a duplicate entry, but i need
to allow the users to be able to manually enter a registration, but stop them
if it matches one of the entries within the data array - is this possible??
From: Roger Govier on 2 Mar 2010 03:32
Hi

Does Debra's example file help
http://www.contextures.com/DataValPlayerInnings.zip

--
Regards
Roger Govier

SNA400 wrote:
> My original problem is listedbelow
>
> I am using Data Validation for selected vehicles on runs, but I need to stop
> people assigning a duplicate registration for seperate runs.
> The list for the data validation is in cells D91 to D120 and the entries are
> made in cells H3 to H47
>
> ALSO - on the same sheet I need to stop people using the vehicle
> Registrations from the validation in cells H48 to H60 - can I use the same
> validation list or do I have to set it up again
>
> I have used all the info from http://www.contextures.com/xlDataVal03.html to
> sucessfully create a dropdown that doesn't show a duplicate entry, but i need
> to allow the users to be able to manually enter a registration, but stop them
> if it matches one of the entries within the data array - is this possible??
 | 
Pages: 1
Prev: Look up table?
Next: calculate hours