Thread: How do I create a spreadsheet that populates q's from a drop down
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default How do I create a spreadsheet that populates q's from a drop down
Angela,

You could use dependent data validation lists:

http://www.contextures.com/xlDataVal02.html

HTH,
Bernie
MS Excel MVP


"Angela" wrote in message
...
I have a worksheet that I need it to populate certain questions when a
specific drop down is chosen. For example, if they choose "Support Service"
from the Drop down box, I want it to populate the questions pertaining to the
Support Service and hide the other questions. Is this possible and is it a
simple formula or a macro? Thank you!


Reply With QuoteReply With Quote