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?
Last edited by budchevy; 05-01-2011 at 09:01 PM.
Hi budchevy,
Look at the attached to see if it does what you need. I'd sort by column B and remove non-current employees.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
That would at least allow me to sort the list and remove the names I don't need much more quickly.
thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks