Copy/Pasting Data in a Workbook
 

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.

Copy/Pasting Data in a Workbook
 

Select to copy your data, then in the other worsheet :
R click paste special check values ok.
enjoy it.

"MCSHMCH" wrote:

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.

Copy/Pasting Data in a Workbook
 

On Sep 27, 8:49 pm, MCSHMCH wrote:
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 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.

Copy/Pasting Data in a Workbook
 

Was it really that easy? YES! Thanks again.

"FC" wrote:

Select to copy your data, then in the other worsheet :
R click paste special check values ok.
enjoy it.

"MCSHMCH" wrote:

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.

Copy/Pasting Data in a Workbook
 

Thank you very much!

"JW" wrote:

On Sep 27, 8:49 pm, MCSHMCH wrote:
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 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.