Sedang Disiapkan

Sort Macro

I need to write a macro to take the information out of the list and put it in another sheet.

Basically, I need to record the outcome of kickable penalties - (seven, five or three points). Kickable penalties are marked by a code in Column P (Eg C1, B2 etc) until either the next score or the end of the half. - Sheet 2 to sheet 3

The following codes from column K describe what decision is taken with the penalty and appear DIRECTLY after the line from above. (penalty for - ...):

PKFT - kick to touch

PKTP - tap

PFSA - scrum

None of the above - kick for goal

Then the score needs to be recorded relative to the attacking team. (ie. Try and conversion against the attacking team should be marked as -7 etc).

Try and conversion = 7 points

Try = 5 points

Penalty / Drop goal = 3 points

I have created some dummy data on sheet3 for you.

Some times both teams win a kickable penalty before any points are scored. In this case, there should be a seperate line on sheet3 for each of the penalties. If Team A wins 20 penalties before the next score, only the first one (with data in column P) is recorded and then the score.

If the half ends before a score is recorded after a kickable penalty is recorded, the score is 0.

The match ID's are included in the matches sheet to give you the two teams for each match.

Can you advise how long and how much this will cost.



Kemahiran: Excel, Visual Basic

Lihat lagi: write five basic need, visual basic cost, three p, matches list, list matches, excel macro how to, what is macro in excel, above the line, the tap, tap, macro, macro excel, macro + excel, line sheet, c1, b2, excel macro sort, sort macro, write macro, excel macro match data, dummy code, macro conversion, seperate line, sort list, excel record macro

Tentang Majikan:
( 1 ulasan ) CT, South Africa

ID Projek: #355009

Dianugerahkan kepada:


I am an experienced programmer and I have something written like this already. It sounds pretty simple. I can have it for you by 5 o'clock if offered by 3. Thank you Jim

$30 USD dalam sehari
(0 Ulasan)

4 pekerja bebas membida secara purata $93 untuk pekerjaan ini


Hi, this should be done in 10 days. Thanks.

$200 USD dalam 10 hari
(0 Ulasan)

Hi Dave, I can do this in no time. Check PM

$90 USD dalam sehari
(0 Ulasan)

Please check my PM

$50 USD dalam 3 hari
(0 Ulasan)