Need help with simple macro

[hamilj03]

I have a worksheet every week of varying lengths. I need a macro that will search the P column. If it finds the entry "Barrett,Courtney" in that column, I need it to change the A column of that same row to "SB/Resi". I imagine this can be simply done through Autofilter. I cannot figure out how to change the A column though. Thanks for your help.

 

[TheNoocH]

see if this works

Sub test()
    For Each cell In Range(Cells(2, "P"), Cells(Cells(Rows.Count, "P").End(xlUp).Row, "P"))
        If cell.Value = "Barrett,Courtney" Then Cells(cell.Row, "A").Value = "SB/Resi"
    Next cell
End Sub

 

[hamilj03]

Works perfectly. Thanks so much!!!