I have been racking my brain for hours trying to find a solution to this issue. My goal is to hide rows 28:36 on the sheet "Inputs" if cell J24 on "Inputs" equals "No". If it equals "Yes" I want to unhide rows 28:36. My issue is that the sheet "Inputs" is created and filled by a macro so I cannot write the code onto the sheet itself, but need to either create a module that will accomplish this or write the code onto a different sheet ("Lease 1") and have it reference the sheet "Inputs". PLEASE HELP!
Bookmarks