Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daily cash report
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
daily cash report
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 On Tue, 16 Oct 2007 08:33:02 -0700, dave wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up a daily analyasis of cash handling of employees | Excel Worksheet Functions | |||
Auto update daily report problem | Excel Discussion (Misc queries) | |||
I need an excel template for "Petty Cash Report" | Excel Discussion (Misc queries) | |||
petty cash report | Excel Discussion (Misc queries) | |||
Cash report template | Excel Discussion (Misc queries) |