Forum Discussion
Filter list based on another cell
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 t...
Are you considering VBA:
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 <> 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