create dependendent drop lists in excel - TechRepublic
General discussion
March 17, 2005 at 12:18 PM
thekays

create dependendent drop lists in excel

by thekays . Updated 16 years, 6 months ago

I am trying to create a number of dependednt drop lists in excel. 3 maybe 4. What i need is for each to be dependent on the previous with a description of the product to be shown in a chosen cell after relevant selections have been made. For example if list one is modes of transport ( eg car boat etc) and car was selected the second list should show makes ( eg ford) and the third list model. After that maybe price or desription based on info somewhere else in the workbook should be shown.

This discussion is locked

All Comments