Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2003 automating new worksheet & transfer balances
Hi, Im a fairly basic Excel user and need help from the experts! I
have just converted a manual daily cash sheet form to an excel spreadsheet. I want/need to automatically generate each new days cash sheet and have it transfer the balances (bank balance & cash on hand) from the previous day. At this time we are copying the original cash sheet template to be used for the current days receipts and manually entering those running balances from the previous day. Is there a way to automate this process so the balances are transferred when each new worksheet is created? Much appreciated! Pamela |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
MS Excel 2003 automating new worksheet & transfer balances
If you press and hold Ctrl while clicking and dragging the worksheet
tab, you can make an exact copy of that worksheet, complete with existing formulas. Does that help? If you want VBA code, you have to provide more details, such as Sample data Explain the layout of the data and formulas HTH, JP On Mar 27, 6:42*pm, wrote: Hi, Im a fairly basic Excel user and need help from the experts! *I have just converted a *manual daily cash sheet form to an excel spreadsheet. *I want/need to automatically generate each new days cash sheet and have it transfer the balances (bank balance & cash on hand) from the previous day. *At this time we are copying the original cash sheet template to be used for the current days receipts and manually entering those running balances from the previous day. * Is there a way to automate this process so the balances are transferred when each new worksheet is created? Much appreciated! Pamela |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
balances in a single worksheet | Links and Linking in Excel | |||
how to carry balances from one worksheet to another | Excel Discussion (Misc queries) | |||
Automating Formulas in Excel 2003? | Excel Discussion (Misc queries) | |||
Automating Excel w VB.Net 2003 | Excel Discussion (Misc queries) | |||
How to link endings balances to beginning balances on different sh | Excel Worksheet Functions |