I’m in need of a macro that will take data from multiple reports and combine them into one. Below are the report requirements and logic along with an attached Report Layout to provide further guidance.
The logic is fairly simple and the [url removed, login to view] report contains all data elements except for the First Name, Middle Initial, and Last Name.
The lookup reference between the two reports will be the EMPLOYEE ID. This is unique and there should only be one row for each employee. Duplicates can be removed once you remove the rest of the unnecessary data in the report. For confidentiality purposes, I have removed unneeded data and changed the sample data elements.
Each [url removed, login to view] file will contain the corresponding [url removed, login to view] which may make it easier for you when combining the various files. Cell C3 will match the EMPLOYEE IDs that are in Column E in the [url removed, login to view] file.
The macro should have a simple button that will run the process once the files have been placed in a central folder and then place the output file in the same folder. Reply with MERGE when bidding so I know you read the full specs. When the macro is finished running, it should save the file as Employee Census and have the current date as well. The format will be CSV. Example: Employee Census [url removed, login to view]
If you have any questions, please let me know. Thanks
19 freelancers are bidding on average $153 for this job
MERGE Hi Anthony, Thanks for the invitation. I have studied the description and would be happy to take on the project. Please confirm and also let me know the Excel version in use. Regards, Arul
"MERGE". How are you doing. I am Usman and I have done a very similar task in Excel before. I would be able to accurately get this project done in 2 days. Kindly discuss. Usman.
Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..
MERGE Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video dem Mere