I have a lot of excel documents that have two columns. Last names (column A) and first names (Column B). Some of the documents have multiple worksheets with the same information. I want to compare all of those names in each file with a master HR excel file that has all the current employees once again in the same format (column A has last names, column B has first). If there is a name that matches a name in the HR list then I dont need anything to be done. But if there is a name that is on a given list but not in the HR list then I want that to be written to a new excel document with a similiar name as the original file. I would want the output format to be the same (2 columns, last name, first name)
I need the script to automatically go through each excel document (inluding mulitple worksheets if they exist for a given document) in the folder.
budget from 30 - 60 dollars
Hello,
I will be glad to take up the project. Solution will be in Excel VBA itself, asking for the master file and the folder containing the other Excels. I can deliver in 1 day. Kind regards.
Sir,
We will do this project in VB.Net as a windows application. We do have a team of experts in .net so we will complete it duly with respect to time..
Thank you.
I'm a systems analyst and work with such problems for a long time, since I created several solutions involving information processing using Excel and VBA.
To resolve this problem I will use my extensive experience here on the subject and some codes that have already done. You will not need additional programs or frameworks installed by merely excel. Trust me, I know exactly what I'm doing and know you will not be disappointed.