moving informatiion from one sheet to a total sheet

  • Thread starter Thread starter john
  • Start date Start date
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
 
have you tried right clicking and doing "paste special" and just copying the
values?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving answer from one sheet to another 1
Summary from multiple sheets 1
Carry data from sheet to sheet automatically 2
extracting totals from 1 work sheet to another work work sheet 2
Count the columns from one sheet and paste it in another sheet 0
Create a list from offset data 9
Sheet to Sheet Totals 5
Setting up macro betwen two sheets 1

Back
Top