Hello everybody, first time here. I've run into some problems with a Excel sheet that I'm doing during my summer internship. I have a sheet with about 50 rows and I would like to hide some specific rows (CI9:CI16, to CN9:CN16) based on the value of the cell CI5. What I mean is that if the cell value of CI5 is equal to 1 I only want to show row number 1. If the value of CI5 is equal to for example 5, I want to hide all the rows with values greater than 5 and show the ones with values less than 5. I'll make sure to leave an image below to clarify further what I mean. I've tried with multiple macros but since I have very limited experience with VBA it's quite difficult to customize the code to my needs. Greatful for any help and feedback that I receive.
14.6 KB Views: 6