I have a spreadsheet with a large number of rows and columns populated with data. Column B is called "Type" and for each row it has a value of either "Simple" or "Configurable" (without the inverted commas). I need a macro that would hide each of the rows where the value is "Simple" in Column B but keep the other rows with a value of "Configurable" showing.
I wondered if anyone could help me with this VBA code?
Really appreciate any help.