I have a result sheet where I want to extract the winner of races from sheet1 to sheet2. My result sheet is 50,000 lines long. See Sample for format.
I want a macro to copy the line that is 2 spaces below the word "Name" that is repeated in Col A and is the separation between the races. Copy A:E there. Put that on sheet 2 Col A as shown in the sample. Then go back to sheet 1 and find the winner of the race which will be the one with a value in column B. Copy A:I there. Go to sheet2 and put that on the same line as the previous entry starting in Col F. Repeat Thanks.
Bookmarks