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? |
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