Scoresheet for car show
 

I am attempting to set up a workbook to track votes for 200 plus classic cars
for an upcoming car show. Each participant will vote for their top 15 picks.
I would like to be able to look at the ballot and type in the car numbers
they are voting for, have it assign the votes to the cell(s) and then sort
the results. This would make the job much easier than searching for each car
number individually.
Excel 2007 Professional