Running Total - Bariloche
Posted by Teri on January 08, 2002 1:37 PM
Thanks, your code worked (kind of) I don't need all cell to add to the right just one, is there a way to specify which column should do this? I had to block out the first sub, because I need to be able to select more than on cell at a time. I just need Total OT Hrs. and Current OT Hrs. to add, and when I open the file the next day, I want to be able to enter new OT hours on top of the old one, but keep the Total OT Hrs. as a running total. The code you gave me kind of does it but it does it for too many columns. I know I'm not explaining this right. If cell b5 has 170 hours in it and I enter 8 more hours in a5 I want b5 to add and to read 178, then on the next day I want to enter say 4 hours in a5 and then b5 should read 183, but whenever I enter any addition hours after the first initial hours the formula reverts back to 170. I hope you understand. Just a running total in one column. Thank you so much.