Hello, I need a macro (in a module) that can replace the employee name with the corresponding employee ID from a different sheet called "roster".
I tried to attach a file as an example but could not figure out how to do it.
I would greatly appreciate any help.
PS: I am not good at writing...