Copy values from Sheet1 to Sheet2

  • Thread starter Thread starter Eintsein_mc2
  • Start date Start date
E

Eintsein_mc2

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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Moving data to sheet2 from sheet1 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
copy data from sheet2 to sheet1 when sheet2 has variable # of rows 6
How to Populate Data from a table to another 0
jump to cell in sheet2 when values in sheet1 is true 3
how can i link sheet1 and sheet2 of book1 1
Automatic populate Sheet2 with data from Sheet1 based on criteria. 2
Fill & Drag to Right !! HELP ! 2

Back
Top