Automatically hiding rows when entering value into cell

Question

Hi all,

So so sorry if this question has already been answered, but I cannot find the answer I need anywhere. FYI: I am not looking for a filter or macro solution to my problem.

I am using one of my excel sheets as a to do list. Can anyone instruct me on how to automatically (so not requiring extra steps from my side like clicking on a macro or filtering again) hide a row when I write 'done' in the first column? I keep having to filter out the to do's I have finished, but I was looking for a way to automate that process.

Thanks!

Sophie

Answer 1

PERFECT! Thank you so so much. I was using the wrong code. You are a master, thank you!

Answer 2

clicking on a macro or filtering again) hide a row

how about online sql tool?

automate filter report generated on web rather than local excel app.

Answer 3

I don't think that's possible without VBA code. The code could run automatically, though.

Right-click the sheet tab.

Select 'View Code' from the context menu.

Copy the code listed below into the worksheet module.

Switch back to Excel.

Save the workbook as a macro-enabled workbook (*.xlsm).

Make sure that you allow macros when you open it.

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim rng As Range
    If Not Intersect(Range("A:A"), Target) Is Nothing Then
        Application.ScreenUpdating = False
        Application.EnableEvents = False
        For Each rng In Intersect(Range("A:A"), Target)
            If rng.Value = "Done" Then
                rng.EntireRow.Hidden = True
            End If
        Next rng
        Application.EnableEvents = True
        Application.ScreenUpdating = True
    End If
End Sub