I want to create a code on VBA for a swimming competition.
I want the code to state if a cell in a worksheet says "New Record", It would use a VLOOKUP to look at the name of event besides it and then to replace the new record time ontop of the current record.
Currently, I have
Which doesn't seem to work
There are two sheets involved, the "New Record" worksheet which is a hidden worksheet where everything is laid neatly and the "current records 6 lane events" worksheet which is also hidden as this sheet is used to be compared to see if any times have broke the record. the cell B2 is an IF function which defines whether the time for row 2 has broke the record. Cell A2 would be the name of the event. The range of A2:D17 is the full list of the records and row 3 shows the times of the current record and the last C2 is the time which is used to break the current record.
Any help would be appreciated
Bookmarks