Find Jobs
Hire Freelancers

Excel/Spreadsheet Data Calculation Automation/Macro Code

$10-30 USD

Closed
Posted almost 8 years ago

$10-30 USD

Paid on delivery
I currently have two excel tabs/spreadsheets that require data calculations to be automated. On the first sheet, I have a list of rows that each have several codes associated with them. We need to produce a code that will do the following for each row in sheet 1: -Search sheet 2 for all the codes that correspond to the given row (in sheet 1) -Grab the values from sheet 2 where the matches were made .Add the totals together and place the final total in tge corresponding column(s) in sheet 1.
Project ID: 10837003

About the project

54 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
54 freelancers are bidding on average $26 USD for this job
User Avatar
Hi, I am good at Excel and vba. Looking forward to work on this project. Plz provide me the details further to discuss. I have read the description. Plz provide me the file.
$34 USD in 1 day
5.0 (913 reviews)
8.0
8.0
User Avatar
Hello! I am an excel expert. I can automate your calculation. You will not be dissapointe. I can do this right now. thank you!
$20 USD in 1 day
5.0 (297 reviews)
7.8
7.8
User Avatar
Hi, I am an Excel macro expert and would be happy to take on your project. Please share the Excel file with data. Shall deliver Excel macro based solution meeting your requirement. Regards, Arul
$50 USD in 1 day
5.0 (173 reviews)
7.4
7.4
User Avatar
Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. I am also able guarantee that I'm able to bring the solution for your project, with the dedication, seriousness and professionalism that it deserves. My work will give you to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. That the confidence to initiate a long term relationship. Thank you for your time.
$25 USD in 1 day
5.0 (161 reviews)
7.0
7.0
User Avatar
Ok. Pretty straightforward forulas and vba code. I write many complex formulas as a daily dose ;) Just contact me and we proceed further.
$34 USD in 1 day
5.0 (141 reviews)
7.1
7.1
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel, macros, and VBA. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$40 USD in 1 day
4.8 (171 reviews)
7.0
7.0
User Avatar
Hey, Can you share the two spreadsheets with some sample data and I would be able to write a formula/script that will get the desired totals. Thanks and Regards, Rishi
$40 USD in 1 day
4.8 (96 reviews)
6.3
6.3
User Avatar
Hi, I am interested for you project. I am able to hard work and I have a small team with 4 members. I hope I will do well for your fully satisfaction. Thank you -Sajib
$25 USD in 1 day
5.0 (63 reviews)
5.7
5.7
User Avatar
Hello, It's a pretty easy job for me to design this macro. Also as I write this message, the macro is already designed in my head. I understand that the macro needs to go to sheet 2 and get corresponding values searched by codes, codes which are present in each row on sheet 1. Sheet1 can have any number of rows, and each row may contain any number of codes - this shall not be a problem for the macro at all. Shall not take more than 2 to 3 hours for me to design that. Can deliver in a single day. Just send me a message, the associated file - and I can discuss further if required, else I can just start working and deliver you a wonderful result within a day. Thank you and with best regards Raad
$27 USD in 1 day
5.0 (32 reviews)
5.3
5.3
User Avatar
HI, I would love to help you with your macro. I am a reporting specialist by trade and I have extensive experience manipulating raw data and automating reports in Excel using advanced functions and macros/VBA. I encourage you to check out my profile and reviews. Your request sounds straight-forward and I believe I can turn it around in the next couple of hours. I look forward to discussing this project with you further. Best regards, Marcelo
$27 USD in 1 day
5.0 (12 reviews)
4.9
4.9
User Avatar
Hi I am an experienced Excel Macro(VBA) developer having expertise in smart calculation solution design. I can provide solution which will automate the calculation process. I would request you to please show the file so I can properly asses the workflow and identifying the ideal solution. If you have any question then please don't hesitate to ask. Hope to hear from you soon. Thanks Best Regards Imran
$20 USD in 1 day
5.0 (20 reviews)
4.7
4.7
User Avatar
Greetings I am a Chartered Accountant  (CPA/ACCA) providing a range of services related to finance, accounts and excel. I have read the project description thoroughly and am confident that I can execute this after knowing further details. I can start working immediately and deliver quick and accurate results. Looking forward to hear from you.
$25 USD in 1 day
4.8 (26 reviews)
4.6
4.6
User Avatar
Hello I have major experience programing on VBA and I believe I can help you. I can have the code ready within the day. Please feel free to send me the files so I can show you what I can do. My bid is $15. Thanks for reading, Michael.
$15 USD in 1 day
5.0 (29 reviews)
4.2
4.2
User Avatar
hi, We are a team of engineers that are working also as Freelancers, from Romania. We are more interested in customer satisfaction and rating than the financial part of projects. If chosen, we guarantee that we will finish the JOB within the deadline specified. Also, the payment is negotiable and we can discuss further about this aspect, if required. We have a many Macro/Visual Basic projects in Excel that we can show, if you want looking forward for your answer, Mihai
$30 USD in 1 day
5.0 (8 reviews)
4.2
4.2
User Avatar
Hi, We knows value of quality and time. We humbly want to work with you with our honesty. We assure You that your project complete in time also within budget. Contact us! Thanks & Warm Regards Asif LILLA Computer Xperts
$30 USD in 1 day
5.0 (34 reviews)
4.4
4.4
User Avatar
dear sir: i am an excel expert having hands on expertise to perform various task on it like formulas placement , conditional formatting, sheets merging and so on. I can do your project as per your requirement in couple of hours. best regards
$40 USD in 0 day
4.7 (12 reviews)
4.2
4.2
User Avatar
Hi, Oh, your project sounds very interesting and simple enough :) It is quite easy to achieve this using a simple VLOOKUP function and I believe that I can have it done during the day. I have over 15 years of experience as Physics and Math teacher; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Access, VBA tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$24 USD in 1 day
5.0 (19 reviews)
4.0
4.0
User Avatar
I can finish this in 3 hours. If you award the project to me now I can start working on it right away.
$25 USD in 1 day
5.0 (16 reviews)
3.7
3.7
User Avatar
Hello, I can do the task in less time, and 100% accurate - I'm a .Net programmer, I write programs using VB6 since 2007, using VB.Net since 2013. - Have long experience with MS-Excel (formulas & VBA macros). - Have long experience with web scraping scraping, winsock applications, FTP connections, math stuff & calculations, applications that works with files & folders, and creating mini-tools that automate tasks while working in background. - Experience with database based applications (MS-Access, SQL Server, and MySQL). - Accuracy and precision is one of my principles, also one of my best advantages. - Commitment to deliver tasks in time. I I'm looking forward to working with you, helping you to solve problems :) Please feel free to contact me to discuss any further details.
$30 USD in 1 day
4.9 (3 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
$10 USD in 1 day
5.0 (15 reviews)
3.8
3.8

About the client

Flag of UNITED STATES
Brooklyn, United States
5.0
12
Payment method verified
Member since Nov 8, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.