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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Is it white?[/TD]
[TD]Is it edible?[/TD]
[TD]Is it cheap?[/TD]
[TD]Is it solid?[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Milk[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Moon[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]Milk[/TD]
[/TR]
[TR]
[TD]Moon[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Is it white?[/TD]
[TD]Is it edible?[/TD]
[TD]Is it cheap?[/TD]
[TD]Is it solid?[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Milk[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]Car[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Moon[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Apple[/TD]
[/TR]
[TR]
[TD]Milk[/TD]
[/TR]
[TR]
[TD]Moon[/TD]
[/TR]
</tbody>[/TABLE]
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.