Find Jobs
Hire Freelancers

Seeking Developer to Edit Excel / VBA Macros

$30-250 USD

Closed
Posted over 7 years ago

$30-250 USD

Paid on delivery
In the Dropbox link ([login to view URL] ) are the following 4 files: Aftermarketmods20160314 - This is the macros we would like to revise. ED Product Database August 2016 - This is a sample input file. OutputOld - This is the output for Input1. Output20160809 - This shows some of the changes to the output we would like. The differences between Output1 and Output20160809 are highlighted and are described below. First step is Workbook Output20160809, Worksheet SKU (based on OutputOld): Column B (Vehicle Year) - There are some fields that are currently blank (for example, SKUPrefix AA_101859 on Row 6568). These rows need to be expanded to 10 rows with years listed for the last 10 years. For example, the current year is 2016, so SKUPrefix AA_101859 should be turned into 10 rows for years 2007 to 2016. If the macros was run next year, then SKUPrefix AA_101859 would turn into 10 rows for years 2008 to 2017. Column D - Formula should be changed to this format: =AL2&" Bodykit and Coupon Code for "&B2&" "&AP2&" "&AQ2&" "&IF(AY2="ALL","",AY2)&" - "&MID(X2,11,99) Column G - Formula should be changed to this format: =U2&" "&AL2&" Bodykit and Coupon Code for "&B2&" "&AP2&" "&AQ2&" "&IF(AY2="ALL","",AY2)&" - "&MID(X2,11,99) Column J - Formula should be changed to this format: =B2&" "&AP2&" "&AQ2&" "&IF(AY2="ALL","",AY2)&" "&AL2&" Bodykit and Coupon Code - "&MID(X2,11,99) Column M - Formula should be changed to this format: =B2&" "&AP2&" "&AQ2&" "&IF(AY2="ALL","",AY2)&" - "&U2&" "&AL2&" Bodykit and Coupon Code - "&MID(X2,11,99) Column AL (Product Type) - "Kit" should be changed to "Body Kit". The next step is create Output20160809, Worksheets Output1, Output2, etc., which can be exported to another workbook if the current workbook uses too much resources. Output1 - See Workbook Output20160809, Worksheet Output1. Output2 - Same as Output1 except: Column C (Product SKU) should be changed to this format: =SKU!F2 Column D (Product Name) should be changed to this format: =SKU!H2 Column G (Description) should be changed to this format: =SKU!G2&SKU!O2 Output3 - Same as Output1 except: Column C (Product SKU) should be changed to this format: =SKU!I2 Column D (Product Name) should be changed to this format: =SKU!K2 Column G (Description) should be changed to this format: =SKU!J2&SKU!O2 Output4 - Same as Output1 except: Column C (Product SKU) should be changed to this format: =SKU!L2 Column D (Product Name) should be changed to this format: =SKU!N2 Column G (Description) should be changed to this format: =SKU!M2&SKU!O2 In addition to the above changes, the GUI should be similar to the current macros because we need to be able to map certain fields to the formulas​​. Thank you.
Project ID: 11327364

About the project

47 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
47 freelancers are bidding on average $136 USD for this job
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$150 USD in 3 days
4.9 (129 reviews)
6.4
6.4
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 270 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD in 5 days
4.8 (102 reviews)
6.2
6.2
User Avatar
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.
$150 USD in 3 days
4.9 (100 reviews)
6.2
6.2
User Avatar
A proposal has not yet been provided
$150 USD in 3 days
4.8 (117 reviews)
5.5
5.5
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VBA/VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex webscrapping, Amazon, aliexpress, VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
$166 USD in 5 days
4.8 (68 reviews)
5.7
5.7
User Avatar
Hello. 47 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$111 USD in 3 days
5.0 (54 reviews)
5.1
5.1
User Avatar
Dear Project Poster, I have relevant hands on 5 years of experience .We have a team of all the skills. I assure you about the work quality and time delivery. Please give me chance to complete this project. I have already deliver the same work in past. I can deliver you in one day. I have 100% client satisfaction ratio. I had already done the same work in past. Looking forward to hear from you. I can make macros compatible with Excel 2007 and that will not use libraries such as Access 2007 or Excel 2010 libraries. Let me give an opportunity to work. We can talk further when you message me.
$85 USD in 2 days
4.9 (48 reviews)
4.9
4.9
User Avatar
Hello, I have been working as freelancer since last ~ 3 years,prior to this was working with a MNC as an Sr. Software Professional. The project is Product based development and integration of the product with various already existing Products and processes.. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in ASP.NET,MVC -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always worked keeping these things during project execution. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Abhinov
$122 USD in 3 days
4.8 (33 reviews)
5.0
5.0
User Avatar
A proposal has not yet been provided
$222 USD in 5 days
4.9 (23 reviews)
4.5
4.5
User Avatar
Hi.. greetings for the day, i have 5+ years of experience in excel vba and i have developed many end to end application s. i can help u in your project. kindly provide me opportunity to work with you. thanks, Mufaddal
$88 USD in 3 days
4.9 (27 reviews)
4.5
4.5
User Avatar
I have the expertise in Excel and scripting in VBA, AND CAN EDIT AS PER THE GIVEN SPECIFICATIONS ACCURATELY.
$100 USD in 2 days
4.5 (56 reviews)
5.1
5.1
User Avatar
Dear client, I have a lot of experience with VBA and Excel. Send me a message for more information. Looking forward to work with u. Kind regards, SlenDATA
$100 USD in 10 days
4.8 (20 reviews)
4.6
4.6
User Avatar
Hi. I have about 15 years of programming experience. Mostly I used C, C++ and C# for my projects development. Let's discuss details of the projct.
$250 USD in 4 days
5.0 (13 reviews)
4.4
4.4
User Avatar
Hi, Your project is not simple and is large. I can do it and give you support on your project I have experience in vba, macros and. Excel programming I have examples if you want yo see By skype Best Regards Luis Augusto Guerra
$200 USD in 10 days
5.0 (2 reviews)
3.8
3.8
User Avatar
Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. My Skills: - I have good skills in Excel automation and used extensively the macros/VBA to automate: - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells,, data camparision using formulas, lookups and bringing up summaries. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Outlook automation - Performing different actions other that using the existing rules, updating calendars based on logic. - MS Access - Expert in designing table, user input forms and also reporting from data. - Excel to MS access data porting and conversion and designing new system for use. - Please review my portfolio on recent projects completed.
$60 USD in 2 days
5.0 (19 reviews)
4.0
4.0
User Avatar
Although the zip file appears to be corrupt after download, I'm making the bid based on the description. I've over 10 years of professional experience, and I'm a trainer of excel VBA. I can deliver the revised macro based template by tomorrow.
$100 USD in 2 days
5.0 (8 reviews)
4.2
4.2
User Avatar
ALREADY IMPLEMENTED FIRST 5 REQUIREMENTS! Only Column AL and Output file requirement pending. If awarded, I can immediately give the updated SW. Greetings Hiring Manager! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH , I have spent at least 200 HOURS on automation in Excel. I can show you some of my work if you can IM me using chat window (Freelancers cannot initiate a chat with Employers on their own - otherwise I would have shared some of my work myself). I can get your work completed within couple of days. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$45 USD in 2 days
4.6 (15 reviews)
3.7
3.7
User Avatar
Hi, I will complete this task in few hours I prefer we chat before you award me this project You can pay me after I have delivered you the working file Looking forward to hear from you Thank you
$100 USD in 2 days
4.9 (7 reviews)
3.5
3.5
User Avatar
I am an expert at vba with 25 years experience. Happy to work with you to ensure you are happy with product I produce
$225 USD in 2 days
5.0 (2 reviews)
2.7
2.7
User Avatar
Hello, dear sir (or miss)! I have registered on the forum not long ago and I have yet completed projects to www.freelancer.com. I am ready to carry out your project in the minimum price and in the shortest possible time and with the highest quality! From the Excel and vba, of course, familiar. Give me a chance to show what I can do!
$50 USD in 2 days
4.8 (4 reviews)
2.4
2.4

About the client

Flag of TAIWAN
Los Angeles, Taiwan
5.0
1
Payment method verified
Member since Aug 3, 2016

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.