Create a drop down list dependent on selection from another list
 

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie

Create a drop down list dependent on selection from another list
 

Click format control
cell link - put for example A1 (gives you the position on the list)
use index function to find results
Eva


"rosiep" wrote:

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie

Create a drop down list dependent on selection from another list
 

Check out this link...

http://www.xldynamic.com/source/xld.Dropdowns.html
--
HTH...

Jim Thomlinson


"rosiep" wrote:

I have 2 combo boxes in 1 sheet.

I'd like the results in the second to be dependent on the result selected
from the 1st.

Is this possible.

Thanks
Rosie