Right now I have it setup to look in column B for a name and then return a value in Column A directly next to it. I have it working for one name, but would I just continue this process over and over per name? Or is there a better approach?
VBA Code:
Sub info()
Dim i As Long
For i = 2 To ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
If ActiveSheet.Cells(i, 2) = "Doe, John" Then
ActiveSheet.Range("A" & i) = "Clothing"
End If
Next i
End Sub