Hide Colum+Row based on value of a cell

[MrSoftee]

Hi,

I was wondering if it's possible to hide a segment of rows and columns depending on the value of a cell. For example, if the value of a cell in the main sheet is "No" , then I need a segment of rows and columns in the second sheet to be hidden. If the value is "Yes" then that segment will become unhidden automatically. I'm pretty sure this is done with a vba code but so far I haven't found one. Any help would be greatly appreciated

 

[LloydFinancials]

Welcome MrSoftee,

How do you know what rows and columns to hide? Is it a lookup? Can you provide concrete example?

Best,

Luke

 

[MrSoftee]

Thank you for your interest but I pretty much figured it out (so far). Basically the code I was interested in goes like this:

Private Sub Workbook_SheetActivate(ByVal Sh As Object)

If Sheets("Sheet1").Range("H38").Value = "Unknown: See RFI" Then
Sheets("Sheet2").Rows("20:21").EntireRow.Hidden = False

Else
Sheets("Sheet2").Rows("20:21").EntireRow.Hidden = True

End If


If Sheets("Sheet1").Range("H49").Value = "Unknown: See RFI" Then
Sheets("Sheet2").Rows("23:25").EntireRow.Hidden = False

Else
Sheets("Sheet2").Rows("23:25").EntireRow.Hidden = True

End If
End Sub

So if the value of a cell in the first sheet is "Unknown: See RFI" then the rows specified (in the second sheet) would automatically appear. Otherwise (for any other value) they would remain hidden. This way only the necessary Request for Information (RFI) will be sent to the customer while omitting everything else

 

[LloydFinancials]

Great. Glad you are on your way.