Read ( FRONT ) page data then transfer that data to the main data Sheet (OPEN)

Hi all and those game to take on this simple task



To start this thread I have a request in the software to start off doing an error check by checking " Front sheet " cells " S4 to U4 ", to ensure they have figures in them, it is possible that the race organisers may only run " 1" Leg due to weather or track conditions, but the typical day is 2 legs totaling " 80 " kms split across the 2 legs. then " Front sheet " ( Sheet 3 ) Cells " X3 to Z3 " if there are No 3rd Leg kms then " Z4 " must read " No Ckpts ".

The normal procedure is that the 80km, before the Ride starts it is possible that a Rider may withdraw their Horse before the ride starts so we need to enter a “ V or W “ into “ Open or Training “ Column “ C “.
Runners leave the ride base at 05:00 in my example I have set it up for 2 x 40 km legs with checkpoints 1,2,3, & 4 in the first leg on the completion of this leg all riders return to the RIDE BASE, ( a Time stamp is entered into the “Base “ following the last checkpoint on record, in our sample case it will be after Ckpts 4 & 8), for compulsory VET checks of the Horses, if at this check it is possible for any mount to be " Vetted Out " which is when " V" is entered against that
rider into " CELL L6 " on the " Front sheet " ( Sheet 3 ) , also a Rider may wish to " WITHDRAW" the mount that too can be entered into L6.

For your info " Front sheet "(Sheet 3) Cell N6 " will return a warning if a rider's number is entered in D6 and that Rider has been issued a " V or W " and cannot participate any further.

This where the work starts, when a rider's number is entered into Cell D6, then in Cell H6 they enter a Checkpoint number or “RIDE/BASE”, in " Front sheet "(Sheet 3) " Cell F6 " it automatically pulls up it indicates which leg that checkpoint is.

As in the sample file " Leg 1" has ckpts ( 1 to 4 ), the next step is to enter the time recorded for that chkpt when a time is entered say 0530 Cell J6 is formatted to show as " 05:30 ", as are all the cells in the OPEN sheet unless there is a " V or W " in " Cell L6 " what we need is to scan the " Open Sheet " ( Sheet 1 ), in this case for Rider number 2 scan across to checkpoint ( 2 ) and enter the time / or contents of Cell " L6 " if Cell " N6 " is flashing ( RED V or W ) then no entry can be made for the rider, because there is already an entry for that rider If they enter a " V or W " in " Front sheet " ( Sheet 3 ) " Cell L6 " this cell will take precedence over the TIME in cell J6 so the contents of Cell L6 will get placed into the cell for " 1st Leg Checkpoint 2 " NOTE: ( when there is a V or W in Cell L6 the cell J6 is cond formatted to go RED so NO TIME can be entered in J6, once all these conditions are met then copy the data over to the " Open Sheet " ( Sheet 1 ), when there is a time entered in " Front sheet " ( Sheet 3 ) " Cell Q6 " This time takes precedence over Cell J6, this time is entered in the next " Open Sheet " ( Sheet 1 ), " Time Out " cell in this case it will be cell " Open Sheet " ( Sheet 1 ), Cell J9, this will change depending on how many checkpoints are in the first leg .

The final instruction is to run the " MACRO Sub ClearCells() " so as to clear all the cells on the Front Page.

Any clarifications please call on me



Peter