Use of pre-defined lists

[Sandor]

I know the Data validation/List option to use a pre-defined list of (i
my case) Companies, but now I'm searching for a way to creat
Department lists, -based on the already filled Company value-.

So, if Company = Site Italy, the Department field should only list th
Italian Departments.

Is there an option for that in Excel

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.Dropdowns.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Paul B]

Sandor, have a look here for a way to do it,

http://www.contextures.com/xlDataVal02.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Sandor]

Thanks both!

The second method was the easiest, because I didn't have to use any VB,
but I might want to use VB in the future when it gets more complex!