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
|
|||
|
|||
a sum from one sheet and to put in an invoice for each mounth
a sum from one sheet in Exel and to put in anther sheet for an invoice
for each mounth |
#2
|
|||
|
|||
Is it possible to have a bit more information? Are the sheets that you want to move the data between in the same workbook? different workbooks? Does the sum need to be dynamic (ie if the number is invoiced for the month and does not change - or will some other changes be made and will the sum need to reflect that in both places?) it's the same if it in two workbooks (and the names don't change) or if it's on two sheets in one workbook. Open both workbooks,select the cell where you'd like the sum for the invoice- put an = sign in the cell, then go to the workbook/sheet where there sum values is stored click the cell and hit return. If it's in a separate workbook- select update when you open the workbook & it will check to make sure the values havent changed. let me know if this is not what youre looking for, cheers, pim -- Pim ------------------------------------------------------------------------ Pim's Profile: http://www.excelforum.com/member.php...o&userid=27565 View this thread: http://www.excelforum.com/showthread...hreadid=470831 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
AUTO FILTER NOT CHANGING RESULTS | Dejan | General Discussion | 25 | October 6th, 2005 02:01 PM |
Index/Contents Sheet | philiphales | General Discussion | 2 | September 9th, 2005 08:58 AM |
Impoting data from Sheet 1 to Sheet 2 | a-leano | General Discussion | 1 | April 20th, 2005 01:05 AM |
Function to automatically insert a new sheet as a result of data entry? | Mark Mulik | Worksheet Functions | 2 | November 28th, 2004 02:21 AM |
Sheet copy with absolute reverence | Peo Sjoblom | Worksheet Functions | 0 | November 17th, 2003 08:16 PM |