Macro for merging data in two Excel spreadsheets

I need a macro created that merges sales revenue and advertising cost data from two separate Excel spreadsheets and creates one spreadsheet with net revenue calculations.

The macro will be used to merge data from two spreadsheets:

1) an Excel spreadsheet that contains sales revenue data from my CRM

2) an Excel spreadsheet that contains advertising cost data from my advertising account (Google Adwords)

I would like the macro to be able to produce the following output:

- net revenue per ad

- net revenue per website placement

I can provide bidders with additional info on the spreadsheets (e.g. column headers), if necessary.

Evner: Excel

Se mere: google excel spreadsheet, google adwords revenue, spreadsheets, merge data, macro e, google spreadsheets, excel 2014 macro, macro spreadsheet, data merging, data google adwords, macro calculations, merge google spreadsheet, google adwords net, merge excel macro, spreadsheet sales data, merge data spreadsheet, excel spreadsheet sales, data merge excel, merge macro excel, excel macro info website, excel crm spreadsheet, sales crm excel spreadsheet, spreadsheet excel sales, excel revenue, excel macro merge excel excel

Om arbejdsgiveren:
( 100 bedømmelser ) Ottawa, Canada

Projekt ID: #6019890

Tildelt til:


I work for an FMCG company and have done an MBA in marketing from IIM C. For my current company I have created many such macros which merge data from different reports and then calculate a metric using these data po Flere

$30 USD på 1 dag
(0 bedømmelser)

37 freelancers are bidding on average $75 for this job


Hi, I'll be happy to help you with this project. Need to see the file Please feel free to message me if you need to discuss any questions you might have prior to award

$94 USD på 1 dag
(83 bedømmelser)

A proposal has not yet been provided

$147 USD in 3 dage
(109 bedømmelser)

Hi, I am interested in your project. You can count on me for a fast and 100% quality job done. Please provide the file. Thanks, Peter

$100 USD in 2 dage
(40 bedømmelser)

I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet to identify the current input and o Flere

$77 USD in 2 dage
(53 bedømmelser)

I can create a simple application for you which will take two excel files as input and give u output excel file in format you are asking. You can use it any time in future even. Keenly looking forward your response.

$50 USD in 2 dage
(30 bedømmelser)

I am an Excel expert. Please take a look at my reviews for Excel projects and consider me to share the sample of both files. I will create the macro to combine the data from both spreadsheets and share it with you for Flere

$66 USD in 2 dage
(77 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

$98 USD på 1 dag
(40 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

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

Hello, It can be done using VBA and/or formulas. It's not possible to say more for now, as I haven't seen the Excel sheets and their structure, but for sure this "combination" of Excel rows it can be done. A few Flere

$76 USD in 2 dage
(20 bedømmelser)

Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba Flere

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

Hi: I have good experience in macros and Excel. I have 100% completion rate with 5-star feedback. Please check my profile to confirm the same. Please let me know if you want to discuss the project.

$55 USD in 2 dage
(14 bedømmelser)

Dear Sir, I have done similar project. Please See my work sample If you like then award me. My work will be accurate perfect in time. Waiting for your reply. Thanks

$50 USD in 2 dage
(31 bedømmelser)

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 demonstrat Flere

$79 USD in 5 dage
(20 bedømmelser)

Hello, my name is Cristian, I have a degree in business and I work with excel every day. Also, I have much experience with spreadsheets and formulas. Greetings.

$61 USD in 3 dage
(12 bedømmelser)

Hello My name is Brent and I am an Excel VBA developer. Based on your requirements, I can complete this project within a day or two. The macro to link the two datasets on a common key is fairly easy to do given t Flere

$50 USD in 3 dage
(18 bedømmelser)

Hello, I am an Engineer from Nova Scotia, Canada. I work for a large Engineering/Project Management company. I am relatively new to Freelancer, but I've programmed countless VBA projects for my employer; budgeting Flere

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

Dear sir, I'm interesting in your job. I have much experience in the MS Excel and VBA. I can do this job. If you want, I can develop a demo within a short time. Regards. PS. In order to show my ability, I c Flere

$90 USD på 1 dag
(6 bedømmelser)

Simple job!!! I can do it for you in a couple of hours. If my quote is high, please feel free to negotiate. Thank you!

$88 USD på 1 dag
(14 bedømmelser)

I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Flere

$30 USD in 3 dage
(10 bedømmelser)

Dear Sir/Madam. I can handle this project. Would you provide me source files of points (1) and (2) please? Wait for your response. Best regards

$70 USD in 3 dage
(8 bedømmelser)