Drop down box - assigning values

[andrewb90]

Hello all,

I am trying to set up a event sheet using drop down boxes to track points and events for each player.

In the event tab:
I have A3:A25 with different events
I have three other sheets with players names on it (A3:A30) labeled Group 1,2,& 3.
Each event uses two players and I would like to (on the event page) select the two players (from 3 lists) and the points that they deserve and have that recorded. If that can fill in a cell on the event sheet, I can use the data to populate a stats printout, I am just unsure how to make these drop down boxes work for me.

Is this doable or should I be looking at another sort of function.
I hope I was pretty clear with what I am looking for.

Thanks,
Andrew

 

[andrewb90]

I was wondering if some sort of VBA would work instead.