I need to get an IC post up!<br/><br/>So, Blinkin, basically, you have thirty lines of spread sheet and you want to just input one number and have it add that number to the total...<br/><br/>What I described works for one line but you would need a new macro for each line....<br/><br/>My honest opinion?<br/><br/>I think you're trying to be too clever.<br/><br/>Use columns.<br/><br/>At the head of each column, enter the player's name, then in the cell below enter "=SUM(x3:x1000)" Where x is the column identifier.<br/><br/>Below each SUM cell, simply enter the results for that player as they come in. The cell will automatically give you a running total.<br/><br/>As long as no player gives you more than 1000 figures you should be fine.<br/><br/>If you know how, freeze the top two rows, with the names and sums in so that as the data extends down they stay on the screen.<br/><br/>If you do go beyond the formula's limit, Excel informs you that you have done so, but the warning is visual, so I don't know if you would pick it up, hence making the sum range HUGE!<br/>