Hi
another alternative:
http://www.xldynamic.com/source/xld.Dropdowns.html
--
Regards
Frank Kabel
Frankfurt, Germany
"John" schrieb im Newsbeitrag
...
I am trying to set up a Dependent List and am having some difficulty.
The
scenario is this
I have a list of Cities to which employees are attached to. I wish to
select
a City and then only to be able to select an employee that is
attached to
that list. The Cities have a Range Name "CityCol" and the Employees
are
listed in columns according to the City they work in, so London
employees
are in AA; Berlin AB; Paris AC ... etc
I select the City in C5 - that's not a problem I can do that. I then
want to
select an Employee attached only to the City selected in C5 from a
drop down
list - this is where I have hit a problem. The formula I have been
attempting to use is with Data Validation - List and is:
=OFFSET(INDIRECT($C5),0,0,COUNTA(INDIRECT(C5&"Col" )),1)
This returns an error "The source currently evaluates to an error"
Don't know if I am even using the appropriate formula
Thanks