therockerz
New Member
- Joined
- Mar 2, 2014
- Messages
- 12
Hi all,
An urgent query and any help will be greatly appreciated.
I have a spreadsheet (with data) with the following structure:
<tbody>
</tbody>
Apologies for the poor example data.
What I need it to do is based on a checkbox input where user will select whether they want to see white/cheap/edible/solid or a combination, and this list will be filtered based on that.
For example, user selects white and/or edible - the result on a different page should be:
<tbody>
</tbody>
Any thoughts on how I can achieve this? In my example, there are just three criteria, but in my work sheet I have around 200 criteria, so advanced filter with "OR" structure would take up too many rows.
Any solution whether VBA/not would be really appreciated!
Thanks.
An urgent query and any help will be greatly appreciated.
I have a spreadsheet (with data) with the following structure:
Name | Is it white? | Is it edible? | Is it cheap? | Is it solid? |
Apple | 0 | 1 | 1 | 1 |
Milk | 1 | 1 | 1 | 0 |
Car | 0 | 0 | 0 | 1 |
Moon | 1 | 0 | 0 | 1 |
<tbody>
</tbody>
Apologies for the poor example data.
What I need it to do is based on a checkbox input where user will select whether they want to see white/cheap/edible/solid or a combination, and this list will be filtered based on that.
For example, user selects white and/or edible - the result on a different page should be:
Name |
Apple |
Milk |
Moon |
<tbody>
</tbody>
Any thoughts on how I can achieve this? In my example, there are just three criteria, but in my work sheet I have around 200 criteria, so advanced filter with "OR" structure would take up too many rows.
Any solution whether VBA/not would be really appreciated!
Thanks.