Macro to hide row on Cell value and row value

[lbanham]

Hi

I am looking for a macro to hide any rows that contain "Month 2" in column D, and also if cell F1 contains "Month 2". This is in Sheet 1 of the workbook.
i would like it to hide/unhide automatically (when cell F1 is changed by data validation) rather than running the macro.

I am using Excel 2010.

Thanks

Lynsey

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Long, i As Long
If Target.Address(False, False) = "F1" Then
    LR = Range("D" & Rows.Count).End(xlUp).Row
    For i = 1 To LR
        Rows(i).Hidden = Range("D" & i).Value = "Month 2"
    Next i
End If
End Sub

 

[lbanham]

Thanks for your reply - sorry for the delay in responding, Christmas Holidays etc.

Unfortunately this isnt working - I may not of explained it clearly.

I will try and explain it differently.
IF the value in cell G3 says "Costs" then all rows should be unhidden. If is says "Sales" in cell G3 any cell in column C with "Costs" in it, these rows should be hidden.

The rows to be hidden would be row 8 onwards.

Thanks again