Report Merge Macro

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 [login to view URL] 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 [login to view URL] file will contain the corresponding [login to view URL] 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 [login to view URL] 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 [login to view URL]

If you have any questions, please let me know. Thanks

Evner: Databehandling, Excel, Visual Basic for Apps

Se mere: report example, simple macro, report layout, macro e, combine excel, census, excel macro download file, csv merge, excel macro match data, save excel read, excel macro row, excel macro read data files, excel macro csv, need match files excel, excel 2014 macro, excel report macro, excel format cell, save report, excel cell format, match merge excel, csv files processing, excel macro reference, macro report, layout report, excel combine macro

Om arbejdsgiveren:
( 16 bedømmelser ) Sarasota, United States

Projekt ID: #6048728

Tildelt til:


MERGE Hi, I have gone through your requirements in detail as well as gone through each of the sample files you have provided. Thanks for providing good clarity on the requirements along with sample files. I wi Flere

$100 USD in 3 dage
(36 bedømmelser)

18 freelancere byder i gennemsnit $154 på dette job


Hello Sir - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among n Flere

$100 USD in 3 dage
(574 bedømmelser)

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

$150 USD in 3 dage
(201 bedømmelser)

"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.

$160 USD in 2 dage
(71 bedømmelser)

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Flere

$200 USD in 10 dage
(124 bedømmelser)

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: [login to view URL] Estate (video demonstration) [login to view URL] (video dem Flere

$95 USD in 5 dage
(132 bedømmelser)

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Flere

$184 USD in 2 dage
(155 bedømmelser)

Hi, I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelanc Flere

$98 USD in 5 dage
(39 bedømmelser)

MERGE In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. I plan to complete the project via writing an Excel macro Flere

$200 USD in 3 dage
(62 bedømmelser)

Merge Hi, I can help you with your requirement. I have closed more than 150 excel projects at various forums. Regards Sawan

$157 USD in 5 dage
(21 bedømmelser)

A proposal has not yet been provided

$210 USD in 3 dage
(26 bedømmelser)

MERGE I have done this type of work, I checked your file and I can do it, based on what I understood it, we need to take the following from master download: Registration Code Employee ID Date of Birth Gender Addr Flere

$136 USD in 2 dage
(73 bedømmelser)

Hello , I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years in IT projects with 5 years working around Microsoft Excel dat Flere

$205 USD in 4 dage
(8 bedømmelser)

Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have many years of experience working with macros and writing code / debugging Excel VBA code. You may che Flere

$135 USD in 2 dage
(34 bedømmelser)

Hi Anthony, MERGE Hope you remember me, We worked together on Excel Graph / metrics macro.. I can complete this project in 2 days. I have done several works like this and can send you sample. Leave a reply to m Flere

$133 USD in 2 dage
(23 bedømmelser)

Hello there, I'm a software engineer with more than 15 years experience in Excel, Access, VBA, VB6, .NET, SQL. Have done many similar projects in the past. I am Top 1% in VBA on Freelancer and lot of experience i Flere

$144 USD in 3 dage
(9 bedømmelser)

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE Flere

$250 USD in 3 dage
(14 bedømmelser)

MERGE Hello there, My name is Conrad Gillard and to show you that I have read the entire spec, I have written "MERGE" at the top of my proposal. I am new to Freelancer, however I am not new to VBA programming. Flere

$111 USD in 0 dage
(8 bedømmelser)