View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eva Eva is offline
external usenet poster
 
Posts: 197
Default 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