Have a roster of names, all hyperlinked to their individual sheets and I have a roster of names that have been updated to reflect current employees. How would one compare the list and highlight any names that do not have a counter part so I can delete them, or highlight names that do have a counterpart?
The hyperlink roster is in Last Name, First Name format while the updated roster is just First Name Last Name
I think my attached workbook is pretty close to my actual sheet and should make it pretty obvious in case my explanation above was confusing!
Bookmarks