automatically hiding a row

[Mattlake]

HI

I hope you can help, I have been looking online and either I dont have the feature or i cannot do it.

I have a table Column B to F and I want to hide the row if column F shows the word Completed.

I have looked at conditional formatting but cannot find how to hide, not even sure where to start on VBA/macros

Is this possible?

Regards

Matthew (always confused)

 

[mumps]

You could simply manually filter the data based on column F not equal to "Completed". If you need a macro to do this, please advise.

 

[Mattlake]

Thanks I was thinking i had made this too complicated and a simple approch would be easier.

Regars

 

[mumps]

You are very welcome.

 

[kvsrinivasamurthy]

Try.

Sub HideRows()
Dim Lr&, T&, S$
Dim M
Lr = Range("F" & Rows.Count).End(xlUp).Row
M = Filter(Evaluate("transpose(IF(F2:F" & Lr & "=""Completed"",""A""&row(F2:F" & Lr & "),False))"), False, False)
For T = 0 To UBound(M)
S = S & "," & M(T)
If Len(S) > 240 Or T = UBound(M) Then
Range(Mid(S, 2)).EntireRow.Hidden = True: S = ""
End If
Next T
End Sub

 

[Mattlake]

Thank you.

That works, I think it would be easier to connect it to a button so it runs when i click button 5)

 

[kvsrinivasamurthy]

Select Developer-->in controls select Insert
Form Controls--> Button
Mark the button on worksheet
Assign the HideRows macro by selecting in Assign Macro dialogue box.
Edit the text in Button as Hide Rows.

 

[Mattlake]

Thank you for all your help with this