Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Petty Cash Log Help
I have started using the petty cash log in the office where I work. I would
like to do a worksheet for each month. I can't seem to get a new sheet started and carry over the balances from the previous month. How do I do this?? Thank you in advance for your assitance. Pat |
#2
|
|||
|
|||
An alternative...
Put all your data on one worksheet. Use one column (Column A) as the month/date indicator. You'll be able to do subtotals, autofilters and lots of nice stuff with the data in one spot. Pat wrote: I have started using the petty cash log in the office where I work. I would like to do a worksheet for each month. I can't seem to get a new sheet started and carry over the balances from the previous month. How do I do this?? Thank you in advance for your assitance. Pat -- Dave Peterson |
#3
|
|||
|
|||
I am sorry. I didn't speak right. The petty cash log I am using is a template
I downloaded from Microsoft's Office additions onlline at their site. It is a beautiful template. The formula is all in place. At the top it keeps track of the balance. At the bottom it keeps a running total of the deposits and withdrawls It keeps the date, amounts, to whom, who received the cash and who approved it. I can copy and past the headers and all to the next worksheet, but it doesn't continue the flormulas over. I would like to be able to send each month's copy to the accountant. As it is now he would get everything all the way back to the first deposit when I first installed this log each month when I would do a printout for him. I would like each month to be on its own sheet and the formulas to continue the totals from month to month as should be done. I hope I stated myself better. Thank you in advance. "Dave Peterson" wrote: An alternative... Put all your data on one worksheet. Use one column (Column A) as the month/date indicator. You'll be able to do subtotals, autofilters and lots of nice stuff with the data in one spot. Pat wrote: I have started using the petty cash log in the office where I work. I would like to do a worksheet for each month. I can't seem to get a new sheet started and carry over the balances from the previous month. How do I do this?? Thank you in advance for your assitance. Pat -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
petty cash report | Excel Discussion (Misc queries) | |||
Cash Flow Distribution/IRR Modeling | Excel Discussion (Misc queries) | |||
I need a petty cash template. can anyone help me? | Excel Discussion (Misc queries) | |||
Need a simple Secretaries Cash Book | Excel Discussion (Misc queries) | |||
Vlookup and Indexing in excel | Excel Worksheet Functions |