copy a sum in cell on sheet 1 (not formula) to cell on sheet 2

[John]

need only the results of a formula to be transferred to sheet 2 ...cannot
have the formula

 

[Ashish Mathur]

Hi,

Copy and Edit > Paste Special > Values

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com