daily cash report

[Guest]

I am trying to enter $ in a13 have it add to b13 for day 1 in month then
enter day 2 in a13 have it add to b13. ie jan 4 sales $2-running month sales
(b13)
then jan 5 sales $5 ads to b13 running month sales
a13 b13
jan4 $2 $2
jan5 $5 $7
will save each day as 1407 start next day enter a13 to add to b13 save as
1507 and so on
Dave

 

[Gord Dibben]

I don't recommend this accumulator method due to the fact there is no "paper
trail" to follow and see where you have made mistakes in entry.

Having said that.......see JE McGimpsey's site for code.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP