+ Reply to Thread
Results 1 to 2 of 2

how to copy and paste similar sheet

  1. #1
    Registered User
    Join Date
    03-28-2011
    Location
    yorkshire
    MS-Off Ver
    Excel 2003
    Posts
    10

    how to copy and paste similar sheet

    Hi,
    I have a number of .xls files that are similar, they contain formatted sheets for printing things like lining component trays and indexing loose leaf folders. They consist of rows and columns that have been formatted to fit the trays or files and each box has symbols (either letters or numbers) sized to fit the box.
    I have decided to try to put them as different worksheets all in the same .xls file.
    If I right click, highlight and copy a worksheet when I paste it (or paste special) it fails to have the correct format.
    The paste special option has a box that says 'ALL' but it only paste the symbols and borders. If I then go back and paste special highlighting column widths it pastes the column width.
    There is no way of pasting the rows? or is there?
    I would assume 'ALL' meant all the choices? rows, columns, formulas, values etc but it doesn't.
    Is there any way of copying a page so it is the same?
    Thanks,
    Bob

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    40,486

    Re: how to copy and paste similar sheet

    Which version of Excel are you using?

    With the destination workbook open, right-click the tab you want to move or copy and select the destination workbook from the drop-down.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

+ 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 sheets to new workbook when sheet names are similar.
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2016, 09:19 AM
  2. Copy all emails in outlook folder and paste them in similar system folder and ms access
    By Megatronixs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2014, 07:31 AM
  3. [SOLVED] copy from one sheet to another triggered by an entry and then pasted if similar log no
    By FlyFisherman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2013, 05:21 AM
  4. Macro to copy specific color cells frm multiple sheets & paste link to other similar wrkbk
    By rahulmalhotra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-05-2013, 11:23 AM
  5. Replies: 5
    Last Post: 12-20-2011, 01:12 PM
  6. Copy color cells from other sheet similar to Lookup
    By unley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-29-2009, 08:52 PM
  7. Replies: 1
    Last Post: 01-04-2005, 06:06 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