how to create a form that will filter data results for a user

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.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top