Alternative......if not too many!

Type the site names into the List dialog in DV.

Agnew Bros,Opunake, etc.

Note the commas must be entered.

Gord Dibben Excel MVP


On Thu, 2 Dec 2004 23:05:07 +0100, "Frank Kabel"
wrote:

Hi
i would create a separate list. e.g. enter the following in B1
=OFFSET($A$1,(ROW()-1)*2,0)
and copy this down
Now use column B as source for your data validation list

--
Regards
Frank Kabel
Frankfurt, Germany

"AndrewB" schrieb im Newsbeitrag
...
how to I limit the data in a drop down list?
ie.
column A has a list of site names, interspersed with month names.
eg. a1 = "Agnew Bros", a2= "Jan", a3="Feb",a4= "Opunake", etc

I've been using a data validation list to pick from, but get all the
month
names listed in the pick list.

How do list only the site names in the pick list?