+ Reply to Thread
Results 1 to 2 of 2

Copy Worksheet Multiple Times to New Workbook, In Order

  1. #1
    Registered User
    Join Date
    01-23-2014
    Location
    United States
    MS-Off Ver
    Excel 2016 - Windows
    Posts
    20

    Copy Worksheet Multiple Times to New Workbook, In Order

    First of all, I created a thread yesterday that User: Leith Ross [Thanks Leith for the help yesterday] was helping me with yesterday. This is a separate question and should be a simple solution.

    I have the following code I'm using to cycle through items in a drop down list, then copy the sheet each time it's updated with a new item to a new workbook. The one thing missing I'd like is if I could have the sheets go in order in that new workbook. Currently - it's a list of 26 cities in alphabetical order - they populate into the new workbook in reverse order, since I'm using =before... I'm sure there is a simple solution i'm missing? I've included the workbook if that helps...

    v2.SectorTemplateHelp.xlsx

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Copy Worksheet Multiple Times to New Workbook, In Order

    Change

    ThisWorkbook.Sheets("SECTOR TEMPLATE").Copy before:=destinationbook.Sheets(1)

    to

    ThisWorkbook.Sheets("SECTOR TEMPLATE").Copy After:=destinationbook.Sheets(destinationbook.Sheets.Count)
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Replies: 0
    Last Post: 06-08-2015, 03:56 AM
  2. Replies: 13
    Last Post: 12-19-2013, 11:06 PM
  3. [SOLVED] copy Activesheet multiple times in same workbook, name from list
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-05-2012, 06:01 PM
  4. Copy multiple worksheets from 2003 workbook to one worksheet in 2010 workbook
    By KeithRoberts in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-06-2012, 10:18 AM
  5. Copy worksheet to WorkBook, from multiple files
    By kaffal in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-07-2009, 11:11 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