moving informatiion from one sheet to a total sheet
 

This is a total from sheet 1 col how can i paste to a total sheet on
another sheet I tried but just get the fomula under the number.
(e1,e,2,e3,3,4) instead of the sum

$12,217.94


$5,418.92
$718.02
$1,086.33

$7,223.27


$2,952.62
$25.00
$692.51
$304.00
$48.52
$327.53
$-
$382.10
$-
$304.51
$223.98
$293.88
$851.36
$73.00
$-
$152.01
$172.50
$-
$156.11
$20.00

$6,979.63
$28,557.64
$28,622.15
$155.00
$39.04

moving informatiion from one sheet to a total sheet
 

have you tried right clicking and doing "paste special" and just copying the
values?

"john" wrote:

This is a total from sheet 1 col how can i paste to a total sheet on
another sheet I tried but just get the fomula under the number.
(e1,e,2,e3,3,4) instead of the sum

$12,217.94


$5,418.92
$718.02
$1,086.33

$7,223.27


$2,952.62
$25.00
$692.51
$304.00
$48.52
$327.53
$-
$382.10
$-
$304.51
$223.98
$293.88
$851.36
$73.00
$-
$152.01
$172.50
$-
$156.11
$20.00

$6,979.63
$28,557.64
$28,622.15
$155.00
$39.04

moving informatiion from one sheet to a total sheet
 

John,

In sheet 1, select and copy the cell with the total formula. Go to the summary sheet,
select the cell where you want the same total to appear. Right-click it, and select Paste
Special. Click Paste Link, OK.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com

-----------------------------------------------------------------------
"john" wrote in message
...
This is a total from sheet 1 col how can i paste to a total sheet on
another sheet I tried but just get the fomula under the number.
(e1,e,2,e3,3,4) instead of the sum

$12,217.94


$5,418.92
$718.02
$1,086.33

$7,223.27


$2,952.62
$25.00
$692.51
$304.00
$48.52
$327.53
$-
$382.10
$-
$304.51
$223.98
$293.88
$851.36
$73.00
$-
$152.01
$172.50
$-
$156.11
$20.00

$6,979.63
$28,557.64
$28,622.15
$155.00
$39.04