Hi, I am a VBA beginner, trying to figure out how to hide rows based on the value of a cell. I have seen similar posts that did not quite answer what I am trying to do.
If cell A3 = "Brand", I want to hide all rows where C9:C2000 NOT= "Brand"
Else if cell A3 = "Other", I want to hide all rows...