+ Reply to Thread
Results 1 to 8 of 8

Copy Worksheet range (several) on a new workbook

  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Sorel-Tracy, QC, Canada
    MS-Off Ver
    Excel 2016
    Posts
    24

    Copy Worksheet range (several) on a new workbook

    Hi everyone,

    I've have the following code to generate seperated pdf file (that's required) BUT now I need to create a new workbook which will have a copy of each generated worksheet (each with their name).

    Please Login or Register  to view this content.
    Note:
    - Template1 is the master template where the macro will be activated (ex. button). Range to be copied to the new workbook and each new worksheet will be A1:I47.
    - Data1 is the tab which have every new worksheet names and the associated content.

    Any suggestion is welcome.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    4,556

    Re: Copy Worksheet range (several) on a new workbook

    Can you attach an Excel sample to show how is the data and display how it works?
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Sorel-Tracy, QC, Canada
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Copy Worksheet range (several) on a new workbook

    Attn PCI, the following code will provide a new workbook with all worksheets renamed BUT content from my template (infos from data1) isn't paste.
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-06-2010
    Location
    Sorel-Tracy, QC, Canada
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Copy Worksheet range (several) on a new workbook

    Here's the sample file
    Attached Files Attached Files
    Last edited by Alternsti; 05-03-2021 at 02:46 PM.

  5. #5
    Registered User
    Join Date
    07-06-2010
    Location
    Sorel-Tracy, QC, Canada
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Copy Worksheet range (several) on a new workbook

    Solved by myself.

    Thanks anyway!

  6. #6
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,779

    Re: Copy Worksheet range (several) on a new workbook

    @Alternsti
    Could you be so kind and post your solved code please.
    For people looking to solve the same problem or similar problem it is very frustrating to see that someone else had the same problem and that it was solved but no solution showing.
    Thank you for your understanding.

  7. #7
    Registered User
    Join Date
    07-06-2010
    Location
    Sorel-Tracy, QC, Canada
    MS-Off Ver
    Excel 2016
    Posts
    24

    Re: Copy Worksheet range (several) on a new workbook

    Here's my solution
    Please Login or Register  to view this content.

  8. #8
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    3,779

    Re: Copy Worksheet range (several) on a new workbook

    Thank you very much Alternsti, very kind of you.
    Good luck

+ 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. Copy range in worksheet into new workbook - input box
    By aleszib in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-10-2018, 10:59 AM
  2. Copy Range from one worksheet;Paste into new workbook
    By skellz022782 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2016, 02:39 PM
  3. Copy One Range of Cells in One Worksheet to Next Available Row in Another Workbook
    By Brad1125 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-28-2016, 07:54 PM
  4. Copy paste worksheet range to existing workbook
    By bhoon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2014, 02:03 PM
  5. Copy text from set range in one worksheet to named worksheet in another workbook
    By Steven811 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2013, 10:55 AM
  6. copy range from active worksheet to another workbook
    By omarq in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-03-2011, 06:21 PM
  7. Copy Range of One Worksheet Into Another Workbook
    By HP RodNuclear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2010, 11:56 AM

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