moving informatiion from one sheet to a total sheet

J

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
 
T

tylermdsm

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

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.
 
Top