L
LoriM1
Hi, I have a Nascar standings excel sheet that looks like this:
Position Name This week's PreviousTotal Total
Points
Points Points
Points Behind
1 Sam 3132
3132 ----
2 Kelly 3094
3094 -38
etc....
Weekly I enter this week's points which adds to previous total point
giving me a new total points. There is also a formula to tell me ho
many points behind the 2nd, 3rd place people are. The problem is
1.the position of the people keep changing, 2.the only way I know ho
to move total points to previous total points is to paste value then
lose the formula for total points and the same goes for the formula i
points behind. Is there a way to do this without reentering all of th
formulas all over again every time I resort the positions and updat
every week
Position Name This week's PreviousTotal Total
Points
Points Points
Points Behind
1 Sam 3132
3132 ----
2 Kelly 3094
3094 -38
etc....
Weekly I enter this week's points which adds to previous total point
giving me a new total points. There is also a formula to tell me ho
many points behind the 2nd, 3rd place people are. The problem is
1.the position of the people keep changing, 2.the only way I know ho
to move total points to previous total points is to paste value then
lose the formula for total points and the same goes for the formula i
points behind. Is there a way to do this without reentering all of th
formulas all over again every time I resort the positions and updat
every week