Forum Discussion
Hide rows in a different sheet based on a value (that contains specific letters)
I have 2 sheets and attached an example: Sheet1 D8 has Baby as value Sheet1 D9 has Man as value Sheet1 D10 has Woman as value The code to search for "ab" in column D and if it finds it somewh...
Sorry I don't understand. It's in my initial post to search for the letters ab and I gave an example with baby but it can be any other word that contains the letters ab written together, for example Gabriel.
The code that you pasted in the sheet it hides rows based on where the actual condition is located in column D in sheet1. I want to specify exactly which row/s to hide if it sees anywhere in column D not only in cell D8.
The code that you pasted in the sheet it hides rows based on where the actual condition is located in column D in sheet1. I want to specify exactly which row/s to hide if it sees anywhere in column D not only in cell D8.
I don't understand either. I give up for now.