View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
Posts: 487
Default Hockey Statistics

Drew,

This can easily be done by building a form that will let you enter the data
for a particular game and then enter it into the correct location on you
spreadsheet. There are some great online tutorials on building forms you
should look at.



"drew1987" wrote:

I have a spreadsheet of wins, losses, points for, points against, Overtime
wins, and number of Shutouts. I have all my data, but I have to manually
type in the new number for a given cell.

Is there a way to make a form or something to ask:
1. Who played?
2. Score?
3. Overtime win?
4. Shutout?

and then automatically update the spreadsheet?