Hi, I want to create Check boxes to hide rows.
There are 3 Check boxes. Design, Sales, Customer

What I want to do is if "D" is typed on Column A in any of the rows, only show rows with "D" in column A if Design Checkbox is clicked. Else, hide all rows with D.

If "S" is typed on Column A in any of the rows, only show rows with "S" in column A if Sales Checkbox or Design Check box is clicked. Else hide all rows with S.

If "C" is typed on Column A in any of the rows, show rowns with "C" in column A is Customers, Sales or Design check box is clicked. Else hide all rows with C.

So prettymuch, i want the macro to scan all lines in Column A to see whether the row is D,S, or C and perform hide row as discussed before.

Any help is much appriciated.

thankyou