I think you want to make a listthen datavalidationallow listsource your
list or name it and =mylist

--
Don Guillett
SalesAid Software

"JMD" wrote in message
...
How do you create a drop down list for several rows and be able to select
from the pick list on a different cell?