I have a large file containing data from a golf tournament I run.
First row contains player name.
Second row shows where they finished.
Columns show the data for each year.
Sheet has over 1000 names (2000 rows)
I'd like to create a new sheet showing only the players and corresponding
data that have competed in the last 5 years (ie any value in the last 5
columns). Is there any function or can I create a macro that will search the
entire sheet and copy to a new sheet column 'A' (name and finish) and both
rows of data for those specific players?