| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
moving entries between workbooks
I'm self employed, for record keeping I have an invoice, expence report and
balance sheet. I fill out the invoice, then the expence report moving the invoice amount to it so I get a snapshot of the week, then the totals from there to the balance sheet. How do I get excell to make those moves for me? -- Steve |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
moving entries between workbooks
Moving things requires VBA or manual operation.
Copying things can be done via cell and sheet linking formulas. See help on "linking" Gord Dibben MS Excel MVP On Sun, 31 Jan 2010 13:33:01 -0800, acetoolguy wrote: I'm self employed, for record keeping I have an invoice, expence report and balance sheet. I fill out the invoice, then the expence report moving the invoice amount to it so I get a snapshot of the week, then the totals from there to the balance sheet. How do I get excell to make those moves for me? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
| Moving The Decimal Point Of Existing Entries | Excel Worksheet Functions | |||
| Calculate a 30-day moving average based on the last x number of entries and date | Excel Worksheet Functions | |||
| Moving workbooks between folders | Excel Discussion (Misc queries) | |||
| moving workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
