Hi!
I have been struggling with a code for a few hours now. I am using this code to automatically hide or unhide rows based on the value in cell I7. The formula in cell I7 is =IFERROR(INDEX(AB2:AQ16,MATCH(C11,AA2:AA16,1),MATCH(I11,AB1:AQ1,0)),""). If the value is 5, I want a specific 5 rows to be available and other hidden. I cannot get the rows to automatically hide/unhide when that value changes. I am wondering if it is because there is a formula in the cell. If anyone has any insight on how to fix this I would really appreciate it!
Here is what I have for the code:
Please Login or Register to view this content.
Bookmarks