Manipulate Excel Data

Completed Posted Apr 25, 2016 Paid on delivery
Completed Paid on delivery

Hello,

Hello,

I have two Excel sheets I need to properly merge together and change some values. Please see the attached ZIP file with both Excel files inside.

Voluum [login to view URL] - This is my main excel file

Sources [login to view URL] - This is my secondary file where we are going to be pulling data from.

What I want done is rather simple for someone that knows how to work with Excel. What I want to do is update the "Cost" data in [login to view URL] from the cost listed in [login to view URL] for each Source ID, then update the profit and ROI data fields using the updated cost we extracted from the other file.

The important part to remember is the data is not in order in both files and some lines are missing so there is no way to simple sort then copy and paste, this needs to be done precisely via a script.

For example in line 10 on the main file we see 16561201 as the Source ID listed in field one then if you look on line 44 of [login to view URL] you will find the same Source ID and see the cost is listed at 76.5271 so in the cost field for [login to view URL] we are going to replace the cost from 191.1135 to 76.5271. We are then going to update the profit and ROI fields. Profit is simply Revenue minus Cost and ROI is simply profit divided by cost expressed as a percentage.

I need someone that can get this done within 1-2hrs.

Data Entry Data Processing Excel

Project ID: #10328383

About the project

39 proposals Remote project Active Apr 26, 2016

Awarded to:

dimkazakos

Hi! I have done a lot of projects like this one. I can complete it in less than 30min. If you are interested in, just chat me. Thank you in advance, Dimosthenis

$40 USD in 0 days
(29 Reviews)
4.8

39 freelancers are bidding on average $37 for this job

paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr More

$45 USD in 1 day
(472 Reviews)
8.4
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$50 USD in 0 days
(496 Reviews)
8.0
Kalpanasekhar

I just checked the attachments. I am ready to complete this project in the next 2-3 hours. My bid is $20. We are ready to provide an immediate work sample. We assure you top notch quality and value for money More

$24 USD in 1 day
(235 Reviews)
8.1
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further detail More

$50 USD in 1 day
(503 Reviews)
7.4
Vasilchenko

Hello Ready to do this in one hour. Just awar me this job. ...........................................................................

$20 USD in 1 day
(91 Reviews)
7.4
zebracaro

I can do it for you quickly and exactly

$50 USD in 1 day
(123 Reviews)
7.1
Tanmoy236

I am extremely good witrh excel as it is part of my daily activities. I have already done 72 work on Freelancer where I got all 4.9 star rating and the employer was extremely satisfied with my work as portrayed by thei More

$40 USD in 10 days
(280 Reviews)
7.1
hdlong66

Hello, I am able to share ready file for your review. Waiting for your response. Best regards, Hoang

$24 USD in 1 day
(182 Reviews)
7.1
johncarteratfl

I am Microsoft Certified Excel Expert. I can hellp you with this task. In your attachments, there is only source. Please text me and send your voluum file (target) file. I will quickly look into it and tell you. I hope More

$45 USD in 0 days
(57 Reviews)
6.2
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready More

$47 USD in 3 days
(102 Reviews)
6.3
hardikshah83

Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr More

$50 USD in 1 day
(24 Reviews)
5.8
choprac

Hello, Hope you are doing good, I read the job description. Here is only one excel file attached "SOURCE REPORT". Anyway, with your description, I can say It’s my kind of work. I can complete the project timely and w More

$50 USD in 1 day
(101 Reviews)
5.6
bashir786wmc

You pay me after checking the work. Hi I have read out all the details given in your project and I am fully capable to deliver you this project with 100% accuracy. I have completed many projects related to this in t More

$40 USD in 1 day
(4 Reviews)
3.3
hialok78

I am a Project Manager in profession working at one of the world's largest I.T. firms. I have more than 10 years of experience in academic writing and Data Entry and ensure that quality work is delivered always. Give m More

$45 USD in 10 days
(2 Reviews)
2.0
dtv1983

Hi i am having 10 years of working experience working with excel and having sound knowledge on excel functions , macro, pivot table and preparing excel programs, i am having Bs degree. i will deliver you good ou More

$25 USD in 1 day
(0 Reviews)
0.0
torobravo

I have the solution already. Let me know where I can send it to you. You review it, and if it is fine, I'll give you the formula unlocked.

$20 USD in 1 day
(0 Reviews)
0.0
ckim46

I am a good candidate for this project because I am detail-oriented and can do it right now within the time limit.

$50 USD in 1 day
(0 Reviews)
0.0
dhathris

Hi, I am an IT Professional with excellent computer skills (MS Excel) and good knowledge of English. I have the required skills to perform this task. Regards, Dhathri. +61449573993

$20 USD in 0 days
(0 Reviews)
0.0
danchos2

i am have so much experience for excel, i am used formule for new base whit other values same numbers o values only u said me u wanna and i create this

$46 USD in 10 days
(0 Reviews)
0.0
Krista83

I couldn't open the excel documents you posted, however I am confident I will be able to get this done very quickly for you.

$55 USD in 1 day
(0 Reviews)
0.0