ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Hockey Statistics (https://www.excelbanter.com/excel-programming/407132-hockey-statistics.html)

drew1987

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?

Don

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?



All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com