Validation

[Carlo]

Hi
I've setup a validation list of stock part numbers linked to a vlookup
and it works fine.

2 issues:
1- I cannot seem to have the list in any other worksheet but the one
with the validation.
2- When I click on the list, but I know what the start of the part
number is, I want to be able to start entering the part code and the
cursor should find the area matching the characters I have entered. Is
there a way to do this?

thanks
Carlob1

 

[Frank Kabel]

Hi
#1:
- place your list on a separate worksheet
- select the data and define a name for this range 'Insert - Name -
Define'. e.g. mylist
- in the data validation dialog use this list name as source:
=mylist

#2: Not possible with data validation