If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|