I've got a list of employees with corresponding titles in one sheet. I need to transfer the cells that are not blank. I might be over thinking this, but I can't figure it out. I've tried macros and indexing formulas, but it does not update properly if I add another name to the list.
Using the attached sheet:
If value in column "B" is not blank then copy corresponding title to column "D," from there I can do a VLOOKUP to pull the employee's name over.
Bookmarks