Not sure if there is more info that would no enable you to do this but
if your total is in A10, in the cell in column B that you want to carry
the sum to

=A10

Does that help?

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=521230