Hi,
I have a list of employee names and IDs in A2:A9 and B2:B9 respectively in Input Sheet and Employee names scattered in Base Sheet.
Employee names should be replaced with their ID's using VBA code. It will be very helpful if someone suggestions to bulk find and replace.
Attached sample book.
Thanks