+ Reply to Thread
Results 1 to 3 of 3

Insert a worksheet template after the last worksheet in a group

  1. #1
    Registered User
    Join Date
    06-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    90

    Insert a worksheet template after the last worksheet in a group

    I have a template for a blank form that I will need to insert multiple times throughout a process. I have a group of worksheets that are all named Section X, from 1 through any integer. I need the new template to be inserted at the end of these worksheets, because after that I have a few worksheets that are named differently.
    I tried recording a macro but it couldn't handle anything except inserting after a specific worksheet. Is it possible to insert this template after the Sections tabs?

    Please Login or Register  to view this content.
    I have attached a workbook showing the place to insert the template, which is called "Section Template". If you need any more information, please let me know!

    Thank you to anyone who helps me figure this out, any responses are appreciated very much.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-15-2013
    Location
    Atkinson, Nebraska
    MS-Off Ver
    Excel 2013
    Posts
    10

    Re: Insert a worksheet template after the last worksheet in a group

    Will the sheet just after your sections thing always be the same? If so, couldn't you just have it inserted right before that instead of having to string compare? Try recording your macro like that.

  3. #3
    Registered User
    Join Date
    06-05-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    90

    Re: Insert a worksheet template after the last worksheet in a group

    Hahaha wow that's exquisitely simple. And yet it's exactly what I was looking for! Thank you very much, acrawl!

+ 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] Use Template Worksheet and VBA to add a new worksheet to active non macro workbook
    By fbplaya02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-30-2013, 01:34 AM
  2. Replies: 4
    Last Post: 10-30-2012, 06:15 PM
  3. Need a template to insert worksheet - NOT workbook
    By WillGe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-06-2012, 12:12 PM
  4. Can't insert custom worksheet template
    By S Car Go in forum Excel General
    Replies: 4
    Last Post: 05-06-2006, 04:35 PM
  5. Macro or OLE method to insert worksheet from template workbook
    By Lyndon Rickards in forum Excel General
    Replies: 0
    Last Post: 01-30-2006, 04:50 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