Hiding A row based on second work sheet based on Yes / No dropdown on first work sheet help....

[TombSpoon]

Hi,

apologies, quite new to fomulas and VBA.

I'm trying to find a way to hide a row of information based upon a yes or no from a dropdown selection in a cell on a different work sheet. For example

On sheet "1 Example" I have selected a "Yes" input in cell "E5" I would like it completely hide row "6" on Sheet "test to name" which contains irrelevant information.

I am quite happy to remove the dropdown menu if simply typing a Yes or No answer makes it more simple.

Many thanks for any help.

S

 

[James006]

Hi,
You can test following

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$E$5" Then Exit Sub
    With Sheets("test to name").Rows("6:6").EntireRow
        If Target.Value = "Yes" Then
            .Hidden = True
        Else
            .Hidden = False
        End If
    End With
End Sub

 

[TombSpoon]

Hi,
You can test following

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target.Address <> "$E$5" Then Exit Sub
    With Sheets("test to name").Rows("6:6").EntireRow
        If Target.Value = "Yes" Then
            .Hidden = True
        Else
            .Hidden = False
        End If
    End With
End Sub

Thanks, thats great. I have just been told, I need to create it without VBA... Would something like this be possible using formulas alone? As in:

If a sheet named "1.Example" cell E5 contains the word "No", Hide all of row 6 on sheet "test to name"?

Sorry, many thanks for the help @James006 !

S

 

[James006]

Glad this is helping you out

Do not want to know who might have suggested to perform this task " without VBA " ... but, unfortunately, it is a joke

 

[TombSpoon]

Glad this is helping you out

Do not want to know who might have suggested to perform this task " without VBA " ... but, unfortunately, it is a joke

Many thanks, i'm as gullible as they come and it was my so called "leader" ... Cheers

 

[James006]

so-called ... for sure !!!