Just an Idea,
you will need to use 3 columns, one column called this weeks points the
other called last weeks points, the third called points this week
create a macro so, that, before you enter new data, cut this weeks
points, and paste special to last weeks points column, then enter
this weeks points in the apropriate place, formulate the point this
week like this weeks points minus last weeks points, this will give you
the individual player points.... well I think you get the idea, by the
way, all the columns do not have to be in the viewing area, depends
what kind of a pool you are working on, is it a points pool or a
fantasy legue