Hello All
I hope you can help.
I am creating a "Product chooser" tool, I have created a simple table with filters which does the job but i want to improve it to make it more user friendly.
My idea is to have questions that the user would answer which would then filter the table below and give the correct model.
For example:
What colour?
What Make?
ect
The answers to these would be done usiong data validation lists and then (and this is where i am stuck) these answers would filter the table below. I guess in a way what I am trying to do is have a pivot table without creating a pivot table (if that makes sense). The reason for not wanting a pivot table is again I want to have it as user friendly as possible.
Is this possible? Can anyone help?
Thanks
I hope you can help.
I am creating a "Product chooser" tool, I have created a simple table with filters which does the job but i want to improve it to make it more user friendly.
My idea is to have questions that the user would answer which would then filter the table below and give the correct model.
For example:
What colour?
What Make?
ect
The answers to these would be done usiong data validation lists and then (and this is where i am stuck) these answers would filter the table below. I guess in a way what I am trying to do is have a pivot table without creating a pivot table (if that makes sense). The reason for not wanting a pivot table is again I want to have it as user friendly as possible.
Is this possible? Can anyone help?
Thanks