Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting cells for worksheet data transfer
Sheet 1 contains two columns. Each column lists a hockey roster. Column A
is the "White" team. Column B is the "Dark" team. There are 22 spots consisting of regulars and numerous substitutes. Any one player may appear on "White or "Dark" from week to week. At the bottom of the rosters will appear the score from a given nights game. On Sheet 2 is a list of all players (regulars and all subs) in column A. Column B is "Wins". Column C is "Losses". Column D is "Ties". My question is: how do I format this so that once I enter the score at the bottom of the rosters on Sheet 1, it records wins, losses and ties for each paler on Sheet 2? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer data from worksheet to another | Excel Discussion (Misc queries) | |||
Excel Worksheet transfer of Data | New Users to Excel | |||
Transfer and save data from one worksheet to another. | Excel Discussion (Misc queries) | |||
Automatic transfer of data from one worksheet to another | Excel Discussion (Misc queries) | |||
Transfer Cell Formatting for linked cells | Excel Discussion (Misc queries) |