Additions

Hey,

I use Excel to run my own Fantasy Football competition with a few mates. I have all of the players listed with their current points total next to their names and then each of the Fantasy teams with the workbooks linked with formulae so that I dont have to enter the points for each player into each team. I just do it once.

For example, if John Smith scores 5 points and he is already on 100 points then I simply use my head and add 5 to 100 and re-enter the points. But it would be alot easier if there was some function that I could use that will allow me to just type in the points he scored in that game and it adds it to the total, or adds it to the previous number in the cell (e.g. if the cell says 100 and I type 5 it changes it to 105).

Thanks for any tips in advance

Christof

Ahh an accumulator. Thats what I need.

Just been playing about with some formulae. I have tried things like =A1+B1 where B1 is the cell that I enter the data into and it gets added to the value already in A1. This would be fine but Excel does some strange thing by altering the values of other cells that are not included in the formula. Strange.

That link you posted looks like it would do the trick but im not all that great with the VBA stuff

Thank you though

Still dont really know what im doing with the code

Can't you just have a column set up for each week of games? For example, on your main data sheet, column A would have the players names, column B would have week 1 scores, colunm C would have week 2 scores etc. Your last column would have the YTD total and you could link this to each individual team tab. This would allow you to retain history and not have to do the math in your head.