Unfortunately the list has 60 names, currently, and is frequently updated.
"Gord Dibben" wrote:
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?
|