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.
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