moving informatiion from one sheet to a total sheet

[john]

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

 

[tylermdsm]

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

 

[Earl Kiosterud]

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.