Filter Information Based on Checkmarks in a form

[amartin13]

Hello,

I'm trying to generate an interactive report that will allow users to quickly see their desired information by using a form. The data is contained on worksheet that includes a column with a specific label and five columns of data. I want those labels to be included as options on a form that when selected will automatically filter the data to just the information they need.

Label examples: Week 1, Week 2, Week 3

Users should be able to select multiple boxes. So if they check weeks 1 and 3, the information will show appropriately.

Do you know where I can begin?

 

[KennyGreens]

Use the filter feature in Excel. Just click the drop down that appears in that first column and they can check off any amount of labels necessary.

 

[amartin13]

I know the filter feature would be simple but my teammates really want something more advanced. Is there a way to place the filter on a separte page so the original data is not seen and the filtered data is viewed without any edits to formatting?