Hi All,
Could someone please help me to write a macro that filters the selection of data based on a cell value?
The situation is:
Let's say I have 2 columns A & B, and I have 2 other cells that I can enter value in them.
I need the macro to auto filter column B by searching the content of cell 1, and then also auto filter column C by searching the content of cell 2.
Using the example below, if I enter grape and paper into Cell 1 and 2 respectively, then it should automatically filter for rows 6-8.
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
I really appreciate any help provided, and happy to clarify if it doesn't make sense!
Many thanks!
Could someone please help me to write a macro that filters the selection of data based on a cell value?
The situation is:
Let's say I have 2 columns A & B, and I have 2 other cells that I can enter value in them.
I need the macro to auto filter column B by searching the content of cell 1, and then also auto filter column C by searching the content of cell 2.
Using the example below, if I enter grape and paper into Cell 1 and 2 respectively, then it should automatically filter for rows 6-8.
| A | B | Cell 1 | Cell 2 | ||
| orange | rock & lemon | grape | paper | ||
| orange | rock & apple | ||||
| orange | rock | ||||
| orange | paper | ||||
| orange | scissor | ||||
| grape | paper & lemon | ||||
| grape | paper & apple | ||||
| grape | paper | ||||
| grape | rock | ||||
| grape | scissor |
<colgroup><col><col><col span="4"></colgroup><tbody>
</tbody>
I really appreciate any help provided, and happy to clarify if it doesn't make sense!
Many thanks!
