Excel Macro to create additional copies of a row, according to IF/THEN

$10-30 USD

Completed

Posted

over 9 years ago

$10-30 USD

Paid on delivery

See attached spreadsheet: Each row is an order that has been exported from our e-commerce system: The order number is in column A. The purpose of the macro is to create additional copies of a row IF there are multiple unique products in that order. The number in column AL is the number of unique products that are in that order. If the number in column AL is one, then the macro will not make a copy of that row. If the number in column AL exceeds 1, then the macro will create copies of that row such that the total number of copies/versions of that row equals the number in column AL: i.e., if the number in column AL is 3, then there will be a total of 3 rows for that order) Attach the macro to the gray button in the upper left corner of the spreadsheet, and then upload the spreadsheet with the new macro, to this project.

Excel

Visual Basic

Project ID: 6738206

About the project

4 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@AlexandrK1

please send the spreadsheet i can complete it in 2-3 hours .

$30 USD in 3 days

5.0

(7 reviews)

3.6

4 freelancers are bidding on average $24 USD for this job

@sajidmahmud

Dear sir I see your project and i do it as your acceptation. I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO and Photoshop work would like to assure you that I will do my job according your expectation. I have a highly creative data entry studio. Just give me your jobs and find out me. Close communication & ON-TIME delivery ensures a long-term relationship with our valued clients. We believe, goodwill in business is worthier than anything else. I give you drafts and unlimited revisions until your satisfaction. I do through research on every project to get the Best result as well as optimum client satisfaction. I can do your job in a best rate. Thanks

$30 USD in 1 day

4.5

(74 reviews)

4.5

@solutionland2014

Hi I'm an IT student with good knowledge in excel and macro. I can do this for you in some hour and good price. I have good experience in this field and can help you to do good job. check my review and my portfolio and let me know if you interested to work with me.

$20 USD in 1 day

4.4

(5 reviews)

2.0

@mwendah

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@nbs127

A proposal has not yet been provided

$20 USD in 1 day

0.0

(0 reviews)

0.0

@ankitaswap1690

A proposal has not yet been provided

$25 USD in 1 day

0.0

(0 reviews)

0.0

@almamun78

I am looking forward to provide quality and unique services. Each and every new task is a challenge for me. I'm very proficient and have valuable experience in Data Entry, MS Excel, MS Word, PDF to Excel, PDF to word, Web Research, and other various related business works. I am hardworking, flexible and detail-oriented. It is my aim to work full-time jobs and to provide excellent service to my clients and I am looking for an opportunity to share my knowledge and skills to buyers. I am self motivated rational communicator

$25 USD in 1 day