+ Reply to Thread
Results 1 to 5 of 5

How to copy and paste whole sheets

  1. #1
    Registered User
    Join Date
    07-19-2013
    Location
    Oakland, CA
    MS-Off Ver
    2010
    Posts
    7

    How to copy and paste whole sheets

    I've got a file with 75 sheets. Each sheet consists of a fairly elaborate header (logo, other design elements, etc.) and columns of data. I'd like to remove each sheet from this "master" file and copy it to its own file. But when I do this, the formatting is all screwed up- the logo and designs are distorted. I tried to adjust the row width and column height to fix it, but it doesn't come out the same (plus it takes forever). Is there a fast and easy way to copy each sheet onto its own file sheet? Hope this makes sense- thanks so much!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,447

    Re: How to copy and paste whole sheets

    Hi and welcome to the forum

    1 way would be to click on the small triangle between the 1 and the A - this will select the entire sheet - then press CTRL X (cut), go to the new file, select A1 and ENTER

    Another way - maybe the easiest/best way - is to 1st make sure you have the new file open, then in the file you want to T/Fer the sheet FROM, right-click on the sheet name, select Move or Copy, select your new file from the To Book drop-down, select where you want it, and select OK. The sheet will be moved (removed) from the old W/B and transferred, as-is, to the new 1
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    07-19-2013
    Location
    Oakland, CA
    MS-Off Ver
    2010
    Posts
    7

    Re: How to copy and paste whole sheets

    Hey FDibbins,

    Thanks for the quick reply and suggestions. I think I may have a problem with version compatibility because when I copy/paste it the numbers are "whited out" on the sheet I'm transferring to. The header shows up smushed but the numbers are gone. What's interesting is that when I first paste or move the old sheet to the new, I can see the numbers under the blue highlighting, but as soon as I click on anything the numbers are gone. I'll try this again when I can use the same version- I think the file is in 2003 and I'm pasting onto 2007.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,447

    Re: How to copy and paste whole sheets

    version should not make a difference with the copy (or cut)/paste - and gowing from 2003 to 2007 wont even cause any problems with the formulas

    lets try this...
    1. open a brand-new blank workbook
    2. go to the "source" file, to the 1st sheet you want to move
    3. click in the square above row 1 and to the left of column A
    4. press CTRL X
    5. select the new file, cell A1
    5. press CTRL V (or enter, both should work)

  5. #5
    Registered User
    Join Date
    07-19-2013
    Location
    Oakland, CA
    MS-Off Ver
    2010
    Posts
    7

    Re: How to copy and paste whole sheets

    Thanks again for the help. It's still not working. Screenshot attached- this is what it looks like immediately after pasting. As soon as I click anywhere on the sheet, the white numbers disappear. The header info remains but it changes color. Kind of bizarre!Excel issue.doc

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy and Paste VBA many sheets
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2013, 11:50 AM
  2. [SOLVED] Copy and Paste over many sheets
    By bjcowen9000 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-19-2013, 01:20 PM
  3. [SOLVED] copy and paste values of all sheets into new sheets
    By greatjobtoday in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2012, 01:44 PM
  4. copy and paste sheets
    By Mile029 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2010, 06:15 PM
  5. Copy and Paste to other sheets
    By emelendez80 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2007, 09:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1