Drop down box problem

T

Todd F

I want to do a simple data validation drop down box so
user can pick "X" or blank. I wan to put the "X" on a
second hidden sheet in work book.

The little box to set up validation list will not allow me
to go to a separate work sheet to choose my LIST.

what is up with that!

Thank you Todd!
 
F

Frank Kabel

Hi Todd
try the following:
- put your data on a second worksheet
- define a name for this data range (goto 'Insert - Name - Define').
E.g. call this range 'data_list'
- select your cell for which you want a drop down-list, goto 'Data -
Validation - List' and enter the following as data source:
=data_list
 
T

Todd F

will keep in mind for other times but this time must have
it in same sheet to deploy to sales force.
 
Top