Thank You Jim, option two worked out perfectly. Thanks

"Jim Thomlinson" wrote:

Two possible solutions depending on what you want. If you want to get the sum
as a static value (will not update if what is being summed is updated) then
copy the cell you want as usual, but when you go to paste the value right
click on the cell you want to paste to and select paste special. Check off
Values and the value will be pasted into the cell.

The other possibility is that you want to get the dynamic value which will
change if what is being summed is changed. In this case you do not want to
copy at all but rather, you want to put a formula in the cell which refers to
the summed total. If this is the case then type = in the cell you want to
show the total and then select the sheet that you want and the cell on that
sheet that you want. Your formula will end up looking something like
=Sheet1!A1. This will pull back the amount in Cell A1 on Sheet 1.

HTH

"DeRizzio" wrote:

I would like to copy a sum from one worksheet to another worksheet. When I
try to copy from one worksheet to another worksheet I get an error message.
How do I proceed?