Manipulate Excel Data

Dokončeno Zveřejněno Apr 25, 2016 K zaplacení v momentě doručení
Dokončeno K zaplacení v momentě doručení

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.

Zadávání dat Zpracování dat Excel

Identifikační číslo projektu: #10328383

O projektu

39 nabídek Projekt na dálku Aktivní Apr 26, 2016

Uděleno uživateli:

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 za 0 dní
(29 recenzí)
4.8

39 Freelnceři na tento projekt zveřejňují nabídky v průměru $37

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 Další

$45 USD za 1 den
(472 Recenzí)
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 za 0 dní
(496 Recenzí)
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 Další

$24 USD za 1 den
(235 Recenzí)
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 Další

$50 USD za 1 den
(503 Recenzí)
7.4
Vasilchenko

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

$20 USD za 1 den
(91 Recenzí)
7.4
zebracaro

I can do it for you quickly and exactly

$50 USD za 1 den
(123 Recenzí)
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 Další

$40 USD za 10 dní
(280 Recenzí)
7.1
hdlong66

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

$24 USD za 1 den
(182 Recenzí)
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 Další

$45 USD za 0 dní
(57 Recenzí)
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 Další

$47 USD za 3 dní
(102 Recenzí)
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 Další

$50 USD za 1 den
(24 Recenzí)
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 Další

$50 USD za 1 den
(101 Recenzí)
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 Další

$40 USD za 1 den
(4 Recenzí)
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 Další

$45 USD za 10 dní
(2 Recenzí)
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 Další

$25 USD za 1 den
(0 Recenzí)
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 za 1 den
(0 Recenzí)
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 za 1 den
(0 Recenzí)
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 za 0 dní
(0 Recenzí)
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 za 10 dní
(0 Recenzí)
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 za 1 den
(0 Recenzí)
0.0