Filtering table with multiple cell values

[stumabe]

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
Stuart

[Blake 7]

Sounds to me like a **** pivot table with slicers may be the way forward... if you upload a sample i'll apply some possible settings for you

[stumabe]

Thanks Blake

Please see attached, the main data is on sheet 1.

On sheet 2 is an example of how I would want it to work, i did find some code on a seperate thread which works but for only one selection...

Thanks Stuart

[Blake 7]

something like this a bit jazzed up may be better than DV lists

[stumabe]

Hi Blake

Thanks very much, I think this will do the job.

Did you happen to look at sheet 2? this has some vba code that I copied when searching for help, it works for one selection (E1) but when you delete the entry it does not delete the filter do you know if there is code for this? This would work slightly better for what i am trying to do but failing that what you have sent should be fine.

Thanks
Stuart

[Blake 7]

hiya - i'm afraid i cant help with VBA, sorry about that. Good luck dude

[stumabe]

No Problem thanks for your help and prompt reply!