cumulative total in a cell
Posted by Tiffany on February 15, 2001 7:58 AM
I have a worksheet in which I need to put a "Total To Date" in particular cells,and then update every week by adding the current week's amounts to arrive at a cumulative total to date. I have searched and searched for answers. I found two instances which involved writing a Macro that puts the cell total into the cell note and then adds the newly entered amount to arrive at the new value to place in the cell. Neither worked, as the cell note would keep the original number and never add anything that was changed in the cell. Help. My DH has to run this report once a week and is more frustrated than I am!!!