Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hockey Statistics
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
looking for a hockey stats template? | Excel Discussion (Misc queries) | |||
Statistics | New Users to Excel | |||
Statistics - p value | Excel Worksheet Functions | |||
template for a hockey pool | Excel Discussion (Misc queries) | |||
p-value, statistics | Excel Discussion (Misc queries) |