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

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

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