Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Block Recalculation of a referenced cell
for game I need to apply a value based on an average that will change with
time. However, I need the applied value to lock as of the time it is posted, rather than changing each time the average changes. There is a "master" sheet which keeps a running batting average for each player based on a fairly complex formula. There is a sheet for each game, and the idea is to copy each player's average at that time, onto the game sheet. however, if I just reference a cell on the master sheet, each game value changes when the average changes. I need to lock each sheet after the game is done. For example if a batter has an average of .248 on game 1, I want to copy that average from the master sheet onto worksheet 1. Four games later, if his average has changed to .264, I want to apply .264 in worksheet 5, but I don't want the value in sheets for games 1,2,3, or 4 to change to .264, but remain based on his average at the time of that game. How do I reference that cell with his average on the day of the game, without having the values on every sheet reflect that? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Block Cell | Excel Discussion (Misc queries) | |||
need value from referenced cell | Excel Worksheet Functions | |||
The absolute referenced cell does not move when source cell moves | Excel Worksheet Functions | |||
See where a cell is referenced | New Users to Excel | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) |