For example, I have the following data set:
<tbody>
</tbody>
I would like to be able to "filter" based on the word "Bananas" and then every row/record in the sheet containing Bananas (irrespective of which column) will be displayed and the rest hidden. In this example, entire rows 2, 4, and 6 would be displayed, the rest hidden. The basic and advanced filters don't seem to work and I haven't found the right macro example that will accomplish this either.
Any help is appreciated!!!
Name | Fruit1 | Fruit2 | Fruit3 | |
1 | Bob | Apples | Oranges | Pears |
2 | Jill | Oranges | Apples | Bananas |
3 | Biff | Apples | Oranges | Pears |
4 | Tad | Bananas | Pears | Peaches |
5 | Peg | Grapefruit | Apples | Pears |
6 | Bill | Bananas | Pears | Oranges |
7 | Don | Oranges | Oranges | Oranges |
<tbody>
</tbody>
I would like to be able to "filter" based on the word "Bananas" and then every row/record in the sheet containing Bananas (irrespective of which column) will be displayed and the rest hidden. In this example, entire rows 2, 4, and 6 would be displayed, the rest hidden. The basic and advanced filters don't seem to work and I haven't found the right macro example that will accomplish this either.
Any help is appreciated!!!