How Do You Copy A Total Formula Value From One Sheet To Another?

[udela]

Hi Guys, I need to know how to copy cells of total values from one sheet to another if any one could help please?
I have 10 columns with 20 rows which each have a different total value, I used the Add tool to total the rows, and dragged the formula to give the total on the other 9 columns. It's all fine, no problem. however when I try to copy the full total row to paste it on another sheet, the numbers do not show & only the REF#### shows on the new sheet! I've tried to format the cells to text, general, numbers, but nothing had worked! Your help would be appreciated. Thank you

[Dave Peterson]

Are you only interested in the values?

Edit|copy your range
Select the destination cell
edit|paste special|values



udela wrote:
>
> Hi Guys, I need to know how to copy cells of total values from one sheet
> to another if any one could help please?
> I have 10 columns with 20 rows which each have a different total value,
> I used the Add tool to total the rows, and dragged the formula to give
> the total on the other 9 columns. It's all fine, no problem. however
> when I try to copy the full total row to paste it on another sheet, the
> numbers do not show & only the REF#### shows on the new sheet! I've
> tried to format the cells to text, general, numbers, but nothing had
> worked! Your help would be appreciated. Thank you
>
> --
> udela
> ------------------------------------------------------------------------
> udela's Profile: http://www.excelforum.com/member.php...o&userid=35244
> View this thread: http://www.excelforum.com/showthread...hreadid=550173

--

Dave Peterson

[Peo Sjoblom]

Paste special > paste link, or paste special as value, the former will
update
You cannot copy the autosum formula that refers to a number of rows from one
sheet to another
because the formula will change from the source sheet to the new sheet and
if you paste into a row with lesser number
than your source formula it will return a ref error

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"udela" <[email protected]> wrote in
message news:[email protected]...
>
> Hi Guys, I need to know how to copy cells of total values from one sheet
> to another if any one could help please?
> I have 10 columns with 20 rows which each have a different total value,
> I used the Add tool to total the rows, and dragged the formula to give
> the total on the other 9 columns. It's all fine, no problem. however
> when I try to copy the full total row to paste it on another sheet, the
> numbers do not show & only the REF#### shows on the new sheet! I've
> tried to format the cells to text, general, numbers, but nothing had
> worked! Your help would be appreciated. Thank you
>
>
> --
> udela
> ------------------------------------------------------------------------
> udela's Profile:
> http://www.excelforum.com/member.php...o&userid=35244
> View this thread: http://www.excelforum.com/showthread...hreadid=550173
>