| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How Do You Copy A Total Formula Value From One Sheet To Another?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) | |||
| Copy Formula That References Another Sheet | Excel Discussion (Misc queries) | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Copying a total from another Sheet | Excel Worksheet Functions | |||
| how do I copy info from one sheet to another via a formula? | Excel Worksheet Functions | |||
Threaded Mode
