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

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

Is there an option for that in Excel?


--
Sandor
------------------------------------------------------------------------
Sandor's Profile: http://www.excelforum.com/member.php...o&userid=27006
View this thread: http://www.excelforum.com/showthread...hreadid=479038