Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
looking for a hockey stats template? bantam Excel Discussion (Misc queries) 2 May 19th 23 03:46 AM
Statistics Kshaver New Users to Excel 1 August 4th 09 06:04 PM
Statistics - p value psipg Excel Worksheet Functions 3 June 14th 08 12:21 PM
template for a hockey pool underdog Excel Discussion (Misc queries) 0 April 8th 08 03:02 PM
p-value, statistics wim rademakers Excel Discussion (Misc queries) 1 January 18th 06 02:23 AM


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"