Advanced Macro Question
Posted on 2004-10-22
I'm building a macro and I need some help.
Suppose I have information in Columns "A" and "B" that never change:
Column A: Suporvisor's Name
Column B: Employee Name
Now suppose I put information into Column D
Column D: Employee Name (The names are the same names in column B, however, they might be on different rows)
I need the macro to put the proper suporvisor's name into column e.
Example: Suzy is in cell b4. Her suporvisor, Linda, is in cell a4. Now suppose I type Suzy's name in cell d50. I need Linda's name to appear in cell e50.