snhalbritter
New Member
- Joined
- Jan 21, 2012
- Messages
- 1
I need to create an excel form for users that will filter responses based on each criteria they enter. The user interface should be the first sheet of a workbook and the data should be pulled from the second sheet. There are multiple categories with multiple options for the user to choose from to filter their results. What are ways to accomplish this?
An example would be that first a user chooses "Medicaid" from a list of "insurance" and then selects that they are a "Veteran" from a list of "beneficiary status", this would then filter the results from the data in sheet 2 that lists Social Services provided in the San Diego area. The content of this question may be superfluous but I need to know how to organize my data in the correct way so that I can create these lists and then get a filtered list of answers for the users. Any guidance on this is greatly appreciated.
I am fairly novice and using excel2010.
An example would be that first a user chooses "Medicaid" from a list of "insurance" and then selects that they are a "Veteran" from a list of "beneficiary status", this would then filter the results from the data in sheet 2 that lists Social Services provided in the San Diego area. The content of this question may be superfluous but I need to know how to organize my data in the correct way so that I can create these lists and then get a filtered list of answers for the users. Any guidance on this is greatly appreciated.
I am fairly novice and using excel2010.
