Create simple looping macro in Excel using VB

$10-30 USD

Completed

Posted

about 8 years ago

$10-30 USD

Paid on delivery

This project involves creating a script that pastes a VLOOKUP code into a cell, and then copies a row of information into the correct row. Step 1: Find the next row with a player code. Step 2: Paste the code into cell A3 Step 3: Copy the information generated from D3:Y3 into the row next to the player code. Step 4: Move to the next row with a player code, and do again. Step 5: Stop the macro when you count 50 rows with no player code The sheet, 'CLEANED', and an example of the output I did by hand are attached.

Excel

Visual Basic

Visual Basic for Apps

Project ID: 10072180

About the project

6 proposals

Remote project

Active 8 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:

@MimiFL

Hi, i m serious freelancer with 100% completion rate and i believe i can help you. I've done hundreds of macros like this one and never had a single problem. That being said i do have a few questions about this macro. For example: What is the starting sheet. I assume you have a list of player codes and for each player code in that list we are opening "CLEANED" worksheet inputing that code in cell "A3" and copying the result. I would need to see the starting sheet, how it looks like. Anyway, as i said i m serious freelancer and i've never took a single dollar unless my solution was perfect. So if you are interested just pm me and we can start with work. Thanks, Milan

$20 USD in 0 day

5.0

(89 reviews)

5.2

6 freelancers are bidding on average $23 USD for this job

@cgullapalli

Hi, I am good at Excel and vba. Looking forward to work on this project. I would like to discuss further on the provided excel files.

$34 USD in 0 day

5.0

(145 reviews)

6.0

@watersev

Hi there, can do it in the next 1 hour. I do not think it would take more then 40-50 min to write. Would require additional explanation. Best regards, Eugene

$15 USD in 0 day

5.0

(145 reviews)

5.8

@bytessolution

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 to develop complex and automated Excel spreadsheets and Access databases, including formulas creation, pivot tables, pivot charts, data manipulation and macros. I 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 the confidence to initiate a long term relationship. Thank you for your time.

$15 USD in 1 day