Thread: How do I create drop-down list boxes from multiple lists/headers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HogLoRidr HogLoRidr is offline
external usenet poster
  
Posts: 1
Default How do I create drop-down list boxes from multiple lists/headers
Sample data:

HEADERS -- Ford Chevy Jaguar Mazda Saab

radio 40 60 100 50 80
cd 80 86 110 65 87
tv 45 55 0 62 91
dvd 130 110 230 98 83

Example (drop down box on another sheet in same workbook) where you select
either Ford, Chevy, Jaguar, Mazda, Saab from the the list box and the
appropraite cells are populated with the correct pricing for radio, cd, tv,
dvd.

Thank you in advance.


Marty
Reply With QuoteReply With Quote