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