Copy/Pasting Data in a Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to copy and paste data with formulas from one sheet into another sheet
within one workbook. I only want the numbers NOT the formula to paste into
the second sheet. Help! Thanks in advance.
 
Select to copy your data, then in the other worsheet :
R click> paste special > check values > ok.
enjoy it.
 
I need to copy and paste data with formulas from one sheet into another sheet
within one workbook. I only want the numbers NOT the formula to paste into
the second sheet. Help! Thanks in advance.
Click to expand...

Select and copy the info you want. Go the the location where you want
to paste the information. Right click and select Paste Special.
Select Values from the dialog box and click OK.
 
Was it really that easy? YES! Thanks again.

FC said:
Select to copy your data, then in the other worsheet :
R click> paste special > check values > ok.
enjoy it.
Click to expand...
 
Thank you very much!

JW said:
Select and copy the info you want. Go the the location where you want
to paste the information. Right click and select Paste Special.
Select Values from the dialog box and click OK.
Click to expand...
 
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

HELP - A formula or sheet you want to move or copy contains the name .... 0
Excel Move or Copy Stopped Working? 0
problems getting this macro to work 23
i need to find the exact location of macro to paste in the existing macro need to get the out put co 0
Macro to copy value in field and insert it into filter 2
Copying data to the next blank row 0
Paste Values in linked Cells Only 4
Special Pasting a work book with many sheets and formulas 2

Back
Top