copy part of a worksheet into a worksheet in the same file/keepi.
 

Excel 2000 My workbook contains 10 sheets. I want to copy one particular
sheet into the middle of every other sheet. I cannot copy and paste because I
lose the format, formulas, etc... I can link , but the user would have to
open the link to view, unless there is a way to keep the link expanded.

copy part of a worksheet into a worksheet in the same file/keepi.
 

Use Paste Special, Values, Paste Special, Formats, Paste Special, Paste
Column widths, Paste Special, Paste Values and Formats, or any of the other
options!

You can do multiple paste specials from the one Copy command into the same
cell, or range. If you want to play around, you can actually Copy a cell,
Paste it, then Paste Special, formats, then Psate Special, Values and so on.
To make it easier, if you do this often, you can use a macro to do the work.

"JTB" wrote:

Excel 2000 My workbook contains 10 sheets. I want to copy one particular
sheet into the middle of every other sheet. I cannot copy and paste because I
lose the format, formulas, etc... I can link , but the user would have to
open the link to view, unless there is a way to keep the link expanded.