Excel, Visual Basic Job by AndyBoydnl

I have somewaht an urgeent request, I need a simple excel macro writing, to organise BMX racers into their race order. I need this done by Friday (15 March, 2013) morning European time. It is quite a simple request and probably no more than an hour or 2 work. I have designed the XLS I just need it automating.

Hope you can help

I will come back to you for further work on the xls if you can deliver this within this tight time frame. Maybe another 2-5 hours, but I have yet to specify that work as it it needs some thought.

let me know ASAP please if you can or cannot do this for me



The Netherlands

Description below and my xls and jpg attached

I have an xls workbook

on the first sheet is a list of names and details of that BMX rider.

I will mark each name with an x if they are present for a BMX race.

I want the macro to find all the people with an x mark and copy that row to the second sheet “Dag Rijders”, pasting it in from row 20, this macro is activated by pushing a button the first sheet i.e:

x Hes van Duuk 3-03-07 6 1

x Duinhoven de Sander 20-03-06 6 1

Then I will open sheet Dag Rijders, and I will manually add the number of riders per race in the top table (13 races max ) e.g. so race 101 will have 5 riders, 102 6 riders etc in row E4:14

The second macro (run by pushing the second button on the second sheet) will take the names (3 columns, B, C &D) of the number of riders required (so in my example first five for race 101) and copy them in the “manche” sheet into the race 101 columns BCD, then the macro will read how many riders for the next race and take the next lot (i.e 6 ) and place them in race 102 table in the manches sheet. This will continue till race 113 or if there is blank or zero for the number of racers


(this has not pasted well see the attached .jpg screen capture)


101 Race 1 Race2 Race3 Pos 1 Pos 2 Pos 3 Totals

Hes van Duuk 1 5 7 #####

Duinhoven de Sander 3 6 4 0

5 4 6 0

7 3 2 0

2 7 3 0

4 1 8 0

6 8 1 0

8 2 5 0

So all the present riders will be populated into their races and then I can print out the “manches” sheet (the position of the tables in the “manche” sheet is set so it prints correctly on A4 please do not move these

Skills: Excel, Visual Basic

See more: writing 101, race writing, project work netherlands, excel macro how to, custom list in excel, 4 hour custom writing, excel mark, andy d, sander, project 2 hours back, i need help in writing my project, i need a custom writing, dag, d max project, copy writing per hour, Bmx, excel macro add, excel macro row, automating excel tables, print repost, xls visual basic, 2013 excel visual basic, screen capture example, excel 2013 visual, project macro

About the Employer:
( 3 reviews ) Heiloo, Netherlands

Project ID: #4329884

8 freelancers are bidding on average $10/hour for this job


Dear Andy, I have it done. Have a look at the file I am going to send. Kind regards

$15 USD / hour
(25 Reviews)

Hi Andy; let me finish your macro in 24h. Regards,

$8 USD / hour
(18 Reviews)

Hi,We will do it in Few hours,We are Excel VBA/VB Expert

$8 USD / hour
(10 Reviews)

****Please check PM. Thanks****

$10 USD / hour
(3 Reviews)

This looks like it can be done with a few simple macros.

$8 USD / hour
(2 Reviews)

ok ill do.......:-)

$13 USD / hour
(0 Reviews)

Hi, can be very simple. i´ll do it as soon as you decide.

$12 USD / hour
(0 Reviews)

need to discuss the first hour monitoring Hy! I am a teacher and I want to work in this project.I work as an informatician since 2001. Thank You!

$8 USD / hour
(0 Reviews)

i strongly believe in result which would be most obvious in least time and low budget as i am over 5 year experience what you need for a particular project.. My work in which I transferred a complicated is visual basi More

$8 USD / hour
(0 Reviews)