My previous request i had twos separate files which was confusing.
I have a template which is made up of two worksheets.
The first one is called racescrape and the second racedata
The racedata worksheet is madeup of an identifier called Race-1 and will contain data column a2 to colm E23.
Race-2 will be in Column A24 and data will be in column A25 to E46 ...... Race-10 column A208 and data A208 .. E 231.
as in the template some may be blank.
First I would like the data under identifiers to be cleared.
Second, the worksheet Racescrape contains data as follows:
A1 the identifier Race-1 and in B1 time
A2 blank and
A3 has headers
A4 contain data until E last row
I need help with writing a macro that will
1. clear the data areas from worksheet racedata keeping identifiers intact
and therafter copy data from worksheet racescrape firstly matching the identifier and copy the data from after the header in Column A to column E last row to the corresponding identifier in the worksheet racedata.
Trust that made myself a little clearer and thank all for help received.
PS the data under the identifiers in racescrape can fluctuate where as the identifier in the worksheet racedata will be fixed.