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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
How to copy & paste a worksheet but change 1 bit of the formula? 1
Copying info from worksheet to worksheet if info matches 2
Worksheet + 1 1
Relative worksheet reference for multiple worksheets in a workbook 5
dynamic data copying between worksheets 0
Copy Worksheet 2
Automatic Cell Copy to other worksheets 1

Back
Top