Expert: Mike Fulcher - 9/24/2006

Question
Hi Mike,

I desire to copy cell value (range A1 to N63) of a worksheet "Details" (some cells with external link, some with formulas, and other worksheets reference) to a new workbook (same name "Details".  This new workbook/worksheet will not have any external link, formulas anymore, only final cell values.  Is this possible?

Answer
Yes, it should be possible.  What you first need to do is copy (Ctrl-C) the desired cells.  Then go to your new sheet, and use the "Paste Special" command under the "Edit" drop down menu.  A window should come up with several options in it.  Select "Values" and this should get you what you want.