I have 2 worksheets: master & nle. One with every employee who has ever worked for the company(master) and the other is all employees who no longer work for the company (nle). Both of these lists are imported and the import can't be altered.
I need to know if there is a way to have the master worksheet lookup names from nle worksheet and remove the names it finds from it's own list?
Bookmarks