Copying data from one sheet to another

[mtcalvaryumc]

I have a column total in sheet one that I would like to copy on sheet 2.
However, I only want the "total" to copy over, not the formula. Is there a
way to do that?

 

[Jacob Skaria]

If both columns/ranges are of the same dimension/number of cells. then Copy
the first list. Select the second list >Right click>Paste Special>check
'Add'. Click OK.

If this post helps click Yes

 

[YESHWANT JOSHI]

Of course, there is a way.
select the cell which u want to copy, press ctrl+c
select the cell where u want to copy, press alt+e+s+v OR
select the cell where u want to copy, select edit, paste special & click on
values and complete the rest of the procedure
u r at the end of your requirement