Creating a drop box in a workbook.
 

You need to create a named range out of your list of data. See here for more
info: http://www.mrexcel.com/td0037.html

Dave
--
Brevity is the soul of wit.


"Mark" wrote:

I am trying to create a drop box in a workbook. The problem I seem to be
having is in understaning how to do this. The data I would like to use in on
another sheet and the data Items spans 5 columns. I would like to make a
simple drop box that has about 10 items in it, but I am having no success
following the help directions,
--
Thanks in advance for your help