| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| drop down list populates data in another cell | Excel Discussion (Misc queries) | |||
| Dropdown List that populates another column | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Create new drop down from previous drop down selection | Excel Discussion (Misc queries) | |||
| Can I create a drop-down list that will reference other drop-down | Excel Worksheet Functions | |||
Linear Mode
