For the current sheet, to show the amount that will be transferred,

=if(and(h300,h30k32),h30-k32,0)

or, for the next sheet

=IF(AND(Sheet1!H300,Sheet1!H30Sheet1!K32),Sheet1 !H30-Sheet1!K32,0)

etc


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390784