+ 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
    15

    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
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,333

    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!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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