I hope some of you Excel gurus can help me with this task. Just a little background:
I am a member pf a photographic club. Each month we run a little competition where we lay out and number some prints and a selection of members (between 10 and 12) serve as judges.
Each judge picks their own top 1st, 2nd, 3rd. 4th, and fifth print, Each simply completes a voting slip and writes the photo number next to the placing, so a completed voting slip may look something like this
Place Photo #
The up to now the secretary has simply taken these slips and by awarding 5 point for 1st, 4 points for 2nd etc has entered them into a spreadsheet like the one on the summary tab in the excel workbook attached.
However this has proven to be very tedious and prone to error. I thought it would be easier simply to enter the photo numbers from the voting slip onto the votes sheet in the attached workbook, and then run a macro that automatically allocated the points to the chosen photos one voting slip per line.
So for example of judge 1 voted
the macro would go to the summary tab and on the Vote 1 row allocate 5 points to Photo 20, 4 points for Photo 12 etc.
The process would then be repeated for each judge, each on a new row.
Sounds good in theory - but how do I make it work?
I hope I've explained it OK, if there are any questions please ask.
I will attach the workbook - (it already as a couple of macros for sorting purposes)