Forum Discussion
Solved
Invisable Rows
Question How do I create (in)visible cells based on a value in a certain cell? Specifications In an Excel file I created I have a number of rows that only need to be visible when a certain quest...
bhushan_z I tried to implement the results I found on Google, but I it didn't work...
I attached the file in this comment. It's about the last two sheets. The cell that contains the question with the Yes / No answer is dark blue. I made the rows that need to vanish light blue.
StijnCl Try the attached file.
Note: Macros are for fixed rows and cells. If you insert/delete rows, it might fail.