How do I create a spreadsheet that populates q's from a drop down
 

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!

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!

How do I create a spreadsheet that populates q's from a drop down
 

Hi,

Why not add a dummy column to the left of all of your questions with the
appropriate group listed on each line that is appropriate. For example,
A2:A10 might read

Sales
Sales
Sales
Support Service
Support Service
IT
Admin
Admin
IT

Select A1:A10 and choose Data, Filter, AutoFilter

Now have the users pick a group from the autofilter in A1.

You can also do this with either a macro of formulas, however, the formula
approach would still leave the cells visible, just not show the questions,
which could be fairly confusing.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Angela" wrote:

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!

How do I create a spreadsheet that populates q's from a drop d
 

Hi Shane,
Thank you I think I will take your advice, that is in terms that I
understand :-))

"Shane Devenshire" wrote:

Hi,

Why not add a dummy column to the left of all of your questions with the
appropriate group listed on each line that is appropriate. For example,
A2:A10 might read

Sales
Sales
Sales
Support Service
Support Service
IT
Admin
Admin
IT

Select A1:A10 and choose Data, Filter, AutoFilter

Now have the users pick a group from the autofilter in A1.

You can also do this with either a macro of formulas, however, the formula
approach would still leave the cells visible, just not show the questions,
which could be fairly confusing.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Angela" wrote:

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!

How do I create a spreadsheet that populates q's from a drop d
 

Hi Shane,
Is there a way that I can hide that column but have the drop down for the
filter in another cell?
For example, Column A is where I have each question labeled, but I want to
hide this column, so how do I have the dropdown to choose the category in
Cell C1? Thank you for all your help,
Angela

"Shane Devenshire" wrote:

Hi,

Why not add a dummy column to the left of all of your questions with the
appropriate group listed on each line that is appropriate. For example,
A2:A10 might read

Sales
Sales
Sales
Support Service
Support Service
IT
Admin
Admin
IT

Select A1:A10 and choose Data, Filter, AutoFilter

Now have the users pick a group from the autofilter in A1.

You can also do this with either a macro of formulas, however, the formula
approach would still leave the cells visible, just not show the questions,
which could be fairly confusing.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Angela" wrote:

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!