How to reference another sheet

[000]

Hello,

I would love some help with creating what should be an easy formula. I need an equation that will look at cell B11 on a sheet titled "Data Entry" and if that cell says "YES", hide row 22 on a sheet titled Office Docs List.

Thank You!!!!

 

[AlphaFrog]

Referencing a cell on another sheet in a formula is easy...
'Data Entry'!B11
...but a formula can't hide a row.

 

[000]

I was trying to throw a line of code in my macro a long the lines of

Rows("22").EntireRow.Hidden = True

I just do not know how to reference the first part of the code.

 

[AlphaFrog]

I didn't realize you wanted VBA code. You had said "formula" in your original question.

Try something like this...

    If Sheets("Data Entry").Range("B11").Value = "Yes" Then
        Sheets("Office Docs List").Rows(22).Hidden = True
    Else
        Sheets("Office Docs List").Rows(22).Hidden = False
    End If

Or just this...

Sheets("Office Docs List").Rows(22).Hidden = Sheets("Data Entry").Range("B11").Value = "Yes"

 

[000]

If Sheets("Data Entry").Range("B11").Value = "YES"
Then Sheets("Office Docs List").Rows(22).Hidden = True

It is having a problem running this code.

 

[Jonmo1]

It's having a problem likely because this

If Sheets("Data Entry").Range("B11").Value = "YES"
Then Sheets("Office Docs List").Rows(22).Hidden = True

Should be like this

If Sheets("Data Entry").Range("B11").Value = "YES" Then
Sheets("Office Docs List").Rows(22).Hidden = True