Home |
Search |
Today's Posts |
#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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Get other sheet names into a column | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
VB copde help - please! | Excel Discussion (Misc queries) | |||
Find a non-blank cell and bring back text a in same row | Excel Worksheet Functions |