Find Jobs
Hire Freelancers

make excel macro for datafeed file - open to bidding

$8-15 USD / hour

Closed
Posted over 6 years ago

$8-15 USD / hour

I have an excel file, that already has existing macros. i need to make a macro with following conditions:- When i run this macro:- 1) everytime it finds a new sku number under SKU column, it will make 15 copies of all the data in that row. So there will be 15 identicial rows with same data 2) in these identical rows, the following changes need to be made. Under "Size" column, the sizes will change from 3, 3.5, 4, 4.5, 5, 5.5, 6....till 10.5 (basically 15 values, one each for the 15 rows) 3) under column "isprimaryvariant" the row with size value 7, will have value "Yes". Other rows will have value "No" all other values remain the same. it is very important that this does not break any existing macros on the file and cause any errors. This is very simple and easy work. I have attached a sample file for you. I need it done very fast within next few hours
Project ID: 16019946

About the project

19 proposals
Remote project
Active 6 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
19 freelancers are bidding on average $12 USD/hour for this job
User Avatar
I love excel automation, and this is an easy job for me; should be done within 5 working hours. ZERO ERROR GUARANTEED!! Please read my 300+ reviews. I am here to impress you with my work.
$15 USD in 10 days
5.0 (200 reviews)
7.1
7.1
User Avatar
Hello, this sounds pretty simple to make, I would love to help you with this project. Please contact me for more information.
$12 USD in 2 days
4.9 (112 reviews)
5.7
5.7
User Avatar
Hi, I have gone through your project details and can help you in getting it done quickly and efficiently. I have worked on similar macro earlier and can help you quickly and efficiently, based on that can write macro as per your need. Waiting for your further response to discuss in detail. Thanks.
$12 USD in 4 days
4.7 (50 reviews)
5.3
5.3
User Avatar
Good day, I am a Sydney Based, English speaking university graduate with 17 years experience using excel to solve complex business problems. I have taken the time to review your project requirements and I am confident I should easily be able to build a nice smooth macro for you. For your reference, please find below some information about myself. My key strengths include: Financial analysis and modelling, Business Case Evaluation, Business Intelligence, Data Extraction, Data Aggregation, Master Data Management, VBA and Macro Troubleshooting / Development, Advanced Reporting and Dashboarding. Over and above my Excel knowledge and skills, I have 12 years corporate business experience and have developed strong commercial acumen around value delivery and customer service. I work quickly, accurately and professionally and am available immediately. Warm Regards Wesley Jeftha
$16 USD in 40 days
5.0 (8 reviews)
4.7
4.7
User Avatar
Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ribbon Buttons, Interaction with external applications for data exchange (Outlook, PDF, Access), etc. Regards Chintu
$11 USD in 30 days
5.0 (6 reviews)
3.8
3.8
User Avatar
I am an expert in excel and macros having more than 10 years of experience, I can finish the job within few days, Please consider me for the job, Please do not hesitate to ask for any questions if you have. Looking forward to hear from you soon.
$8 USD in 40 days
4.6 (12 reviews)
3.5
3.5
User Avatar
Hey, I am working as a Data Analyst in IPSOS company. I have to deal with macros on dealing basis. I can make exact same macro for you which you have asked for. I will do it quickly within next few hours without any mistake. Feel free to contact me anytime. Thanks, Muhammad Farhan
$9 USD in 30 days
4.4 (9 reviews)
3.2
3.2
User Avatar
Hi there! I’m Bhakti from India and I’m really interested in the project you’ve posted. No sample file attached there. Please attach file. My best skills are: Web scraping, Web searching, VBA, Transcribe pdf to other format, Copy typing and Other skills. Hope you will contact me. Thank you :)
$12 USD in 1 day
5.0 (3 reviews)
2.8
2.8
User Avatar
A proposal has not yet been provided
$8 USD in 40 days
5.0 (2 reviews)
1.6
1.6
User Avatar
Hi There, I have a expert team of excel,I will give create your your macros according to your requirements and i will not disturb your macros. Need to discuss over chat PM ?
$16 USD in 20 days
3.0 (1 review)
2.0
2.0
User Avatar
hello i understand your requirements and i can do your work with quality and with your full satisfaction as i m expert in this work. Please send me details in my inbox so we can start it
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Dear, Hope you are doing great. I have been through your requirements. I would like to work with you. I always aim to provide quality work within precious time. I look forward to your professional and kind feedback. Please feel free to discuss your project with me. Regards
$12 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$11 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
This is a really simple task. I could have this written up really quickly and could teach the logic behind it, if desired. I would also be interested in future projects if it seems you may have other VBA/Excel related projects. I look forward to hearing back from you. Thank you, Michael Lowery
$15 USD in 15 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of NIGERIA
Ikeja, Nigeria
0.0
0
Payment method verified
Member since Jan 5, 2018

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.