Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy & pasting formulas across workbook tabs Anne Reichler Excel Worksheet Functions 1 June 7th 07 09:25 PM
Copy and pasting on columns but on spreadsheet with alot of data Michael Excel Discussion (Misc queries) 2 October 10th 06 01:49 PM
Search Data from one Workbook and copy it into another Workbook Matz Excel Discussion (Misc queries) 0 August 4th 06 10:45 AM
Copy Data from Workbook into specific Worksheet in other Workbook? kingdt Excel Discussion (Misc queries) 1 March 16th 06 06:55 PM
copy excel workbook to new workbook without data Omnitool Excel Worksheet Functions 3 March 14th 06 10:49 PM


All times are GMT +1. The time now is 01:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"