Filter list based on another cell

Question

Creating a project timesheet where employees input their hours each week for each project so we can appropriately charge the client. I need it to function so when the employee selects their name in the validation drop down list it automatically filters out everyone else's project hours for that week.

E.g. They would select their initials in cell C2 and it would automatically hide all the rows and only show the corresponding rows for the selected employee. So for employee "FC" it would go from looking like this...

To this...

Alternatively, if there is a far easier way of doing this would love the advice.

Thank you

kidd_ip · Answer

Are you considering VBA:
&nbsp;
Sub FilterRowsByInitials()
    Dim ws As Worksheet
    Dim lastRow As Long
    Dim initials As String
    Dim i As Integer

Set ws = ThisWorkbook.Sheets("YourSheetName") ' Change to your sheet name
    initials = ws.Range("C2").Value ' Cell with dropdown
    lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row ' Change column as needed

For i = 2 To lastRow ' Assuming headers are in row 1
        If ws.Cells(i, "A").Value &lt;&gt; initials Then ' Change column "A" to your Initials column
            ws.Rows(i).EntireRow.Hidden = True
        Else
            ws.Rows(i).EntireRow.Hidden = False
        End If
    Next i
End Sub
&nbsp;

Forum Discussion

Filter list based on another cell

1 Reply