Copy values from Sheet1 to Sheet2

I am no guru when it comes to Excel, so I was wondering if someone
could please help. I need a formula that will copy values from sheet1
into sheet2, but then I want to clear the values in sheet1 & still keep
the values in sheet2. Sheet1 has my weekly figures on it and sheet 2
will calculate those figures to give me a monthly figure.

You can just link them, copy them, select where you want them on the other
sheet and
do edit>paste special and select paste link, then while still selected copy
the pasted values and
do edit>paste special as values, that will keep the values but remove the
reference to the original sheet,
now you can clear the values in Sheet1

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Eintsein_mc2" <[email protected]> wrote in message
news:[email protected]...
>I am no guru when it comes to Excel, so I was wondering if someone
> could please help. I need a formula that will copy values from sheet1
> into sheet2, but then I want to clear the values in sheet1 & still keep
> the values in sheet2. Sheet1 has my weekly figures on it and sheet 2
> will calculate those figures to give me a monthly figure.
>