Manipulate Excel Data
$20-50 USD
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.
Project ID: #10328383
About the project
Awarded to:
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
39 freelancers are bidding on average $37 for this job
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.
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
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
Hello Ready to do this in one hour. Just awar me this job. ...........................................................................
Hello, I am able to share ready file for your review. Waiting for your response. Best regards, Hoang
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
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
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
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
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.
I am a good candidate for this project because I am detail-oriented and can do it right now within the time limit.
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
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
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.