I have a very basic knowledge of excel.
We want to create an excel spreadsheet that will tally the number of votes for a particular artist's work. There will be about 150 artist's works that will all be assigned an individual number from 1 to 150 on an excel sheet.
We will have about an hour to complete the counts to determine winners, so a short time frame.

Is there a way of creating a formula/macro in one cell -to just enter the number of the artist's work that was voted for- and have it placed as a tally against the individual piece?
Thanks very much.