Hiding rows

[Ninakitkat]

Hello. I have a spreadsheet that is constantly being updated with new data that Ishare with others but need to hide the rows once that task is completed. I have a formula that ties all the rows to one subject but want them to hide once another cell is marked Y. Can someone help me figure out how to do that? This is what I'm working with:

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming ..

1. The "Y" values in column C are not the result of a formula
2. There is at least 1 blank cell between each number in column B

.. then you could try this Worksheet_Change event code with a copy of your workbook. To implement ..
1. Right click the sheet name tab and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window & test.
4. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm).

Private Sub Worksheet_Change(ByVal Target As Range)
  Dim lr As Long
  
  If Target.CountLarge = 1 And Target.Column = 3 Then
    If UCase(Target.Value) = "Y" Then
      lr = Target.Offset(1, -1).End(xlDown).Row - 1
      If lr = Rows.Count - 1 Then lr = Target.Offset(1, 1).End(xlDown).Row
      Target.Resize(lr - Target.Row + 1).EntireRow.Hidden = True
    End If
  End If
End Sub