| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & pasting formulas across workbook tabs | Excel Worksheet Functions | |||
| Copy and pasting on columns but on spreadsheet with alot of data | Excel Discussion (Misc queries) | |||
| Search Data from one Workbook and copy it into another Workbook | Excel Discussion (Misc queries) | |||
| Copy Data from Workbook into specific Worksheet in other Workbook? | Excel Discussion (Misc queries) | |||
| copy excel workbook to new workbook without data | Excel Worksheet Functions | |||
Linear Mode
