I gang

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 [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

Færdigheder: 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:
( 15 bedømmelser ) Sarasota, United States

Projekt-ID: #6048728

Tildelt til:

excelsolution

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 Mere

$100 USD in 3 dage
(44 bedømmelser)
4.5

19 freelancere byder i gennemsnit $153 for dette job

deepbluetech

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
(147 bedømmelser)
6.2
maverick44000

"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
(42 bedømmelser)
6.1
nagybatonyi

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 Mere

$200 USD in 3 dage
(53 bedømmelser)
5.7
avinav606lx

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 Mere

$184 USD in 2 dage
(57 bedømmelser)
5.6
jaylancer43

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 Mere

$100 USD in 3 dage
(64 bedømmelser)
5.5
dpune

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 Mere

$200 USD in 10 dage
(41 bedømmelser)
5.3
ethicalboy

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 Mere

$136 USD in 2 dage
(50 bedømmelser)
5.1
abdellatif81

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 Mere

$205 USD in 4 dage
(6 bedømmelser)
4.8
SoftwareEng8876

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

$250 USD in 3 dage
(27 bedømmelser)
4.8
tuhindo82

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 Mere

$250 USD in 3 dage
(18 bedømmelser)
5.1
sawangupta

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
(11 bedømmelser)
4.6
naveenvarthaan

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 Mere

$133 USD in 2 dage
(20 bedømmelser)
4.5
vikas0903

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 Mere

$98 USD in 5 dage
(9 bedømmelser)
4.3
adim

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 Mere

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

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 Mere

$135 USD in 2 dage
(12 bedømmelser)
4.0
super2lao

A proposal has not yet been provided

$147 USD in 3 dage
(4 bedømmelser)
4.0
paris2785

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

$95 USD in 5 dage
(22 bedømmelser)
4.0
rinsadsl

A proposal has not yet been provided

$210 USD in 3 dage
(10 bedømmelser)
3.7
ConradGillard

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

$111 USD in 0 dage
(1 bedømmelse)
0.9