will keep in mind for other times but this time must have
it in same sheet to deploy to sales force.
-----Original Message-----
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

--
Regards
Frank Kabel
Frankfurt, Germany


Todd F wrote:
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!

.