Hi again,

Am Fri, 19 Dec 2014 00:17:54 -0800 (PST) schrieb L. Howard:

Dependent drop downs on Sheet1.
First drop down in B2 & source is =Division_List
Second drop down in C2 & source is INDIRECT(B2)

the depending list must have a fix range. It will not work with dynamic
range names


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional