See
http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sandor" wrote in
message ...
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