accumulate values in a single cell
Posted by Peter on January 21, 2002 4:40 PM
I wish to show a Month to Date $ value in a single cell using daily input of production hours x $ rate.
I used simple formulae to achieve the daily total but am stumped on how to add it to the previous days total.
Posted by Jacob on January 21, 2002 5:14 PM
Hi
Lets say the running total is in A1 and the current days total is in B1 then
Sub MyMacro()
range("A1").formulaR1C1 = range("A1").value + range("B1").value
end sub
HTH
Jacob
