+ Reply to Thread
Results 1 to 2 of 2

Excel copying a worksheet from a workbook to another

  1. #1
    Registered User
    Join Date
    03-15-2022
    Location
    New Jersey
    MS-Off Ver
    Office 365
    Posts
    1

    Excel copying a worksheet from a workbook to another

    Hello

    I'd like to know how to duplicate (copy) a worksheet from one workbook to a different workbook's worksheet. Using the copy (worksheet) from a workbook to replace an existing worksheet in another workbook.

  2. #2
    Valued Forum Contributor
    Join Date
    01-07-2022
    Location
    East Asia
    MS-Off Ver
    Office 365
    Posts
    311

    Re: Excel copying a worksheet from a workbook to another

    If I understand your question properly, you need to do this in two steps. For clarity, I've named the workbooks and worksheets in brackets:

    1) Copy worksheet across from one workbook (Workbook 1) to another (Workbook 2). Step by step guide for this at https://www.ablebits.com/office-addi...other-workbook

    2) There's no replace worksheet function, so if the worksheet you copy across (Workbook 1 Sheet A) has the same name as another worksheet already in Workbook 2 (Workbook 2 Sheet A) , it will rename itself as Sheet A (1). Manually delete the original Workbook 2 Sheet A, and rename Workbook Sheet A (1) as appropriate.
    <<< Please click * to thank valued contributors

+ 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. Copying worksheet to other workbook image is not copied to other workbook
    By meneertjebeertje in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-17-2018, 04:13 AM
  2. [SOLVED] Copying a worksheet from a workbook and save it as a new worksheet based on a list. VBA
    By malitec in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-05-2015, 03:07 AM
  3. Replies: 2
    Last Post: 05-01-2013, 06:17 AM
  4. [SOLVED] Copying worksheet from another open workbook using variables, paste to active workbook
    By sanpedro_nz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-08-2012, 08:25 AM
  5. Copying filtered data from one worksheet to a worksheet in another workbook
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2011, 09:13 AM
  6. Copying named worksheet from a workbook to a new workbook
    By s999 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-16-2010, 01:09 PM
  7. [SOLVED] Copying A Worksheet From Each Open Workbook to an new Workbook
    By carl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-03-2006, 01:40 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