I would like to add drop down lists to the attached model.
1. Excel displays drop down list in Calculation!B9 containing Airports. Airports are listed on on the Air Freight!B1:B5
2. User selects Airport from the drop down list in B9
3. Excel displays drop down list in B13 containing Airlines that fly to the selected Airport. The list is on the AirFreight sheet.
4. User selects the desired Airline.
Thanks for your help.