Sugestions on how to make the best view

[CenaDK]

Hey guys.

Sorry for the not helping title, but I was not sure what to call it, because I'm not 100% sure what I'm asking for.
At the moment i got a spreadsheet with a lot of data.

On another sheet I want to make a easy viewable GUI with some buttons, where it's possible to do some sorting in the data.

Sheet1 Rows(Head sheet):
Name:
Age:
Hair colour:
ShoeSize:
Clothes size:

Sheet 2:
On the other sheet i want a GUI with headlines named(Maybe with checkboxes):

Name
Age
Hair colour
ShoeSize
Clothes size

I want to make it possible for the user to choose fx. age and shoesize.
When they choosen those, I want to make a button (Next fx), and after that they will have the possiblity to choose between fx. age 10-20, 20-30, 30-50 etc and some shoesizes to.
When they have made this new decisson I want a new button, where they can click and then the spreadsheet show to ones who fullfilled the choosen criterias.


Does it make any sense at all?


The button line is I don't know the best way to do what I want on Sheet 2.
Is it best to make headlines with checkboxes, comboboxes or something else? Or do you got a completely different sugestion.

If you don't understand what I want, I will try to see if I can make a spreadsheet with the idea in my head, to make it more easy to visualize

Thanks in advance

/CenaDK

[Matt_]

Could put on option buttons and set up an on 'change' event - if buttonAge.value = true then comboboxAge.enabled = true.

or something like that...

then you could put the data in a table and have it filter based on those choices.

[CenaDK]

Could put on option buttons and set up an on 'change' event - if buttonAge.value = true then comboboxAge.enabled = true.

or something like that...

then you could put the data in a table and have it filter based on those choices.

Can you explain a little further? I'm not sure what option buttons is and how it's working.

I was thinking I could maybe use some form checkboxes and maybe a command button who check which checkboxes are true/false.
But I'm not sure wheter there is a smarter way to it.