+ Reply to Thread
Results 1 to 4 of 4

VBA to copy a template sheet to all other sheets except specific sheets to be excluded

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    canterbury
    MS-Off Ver
    2010
    Posts
    3

    VBA to copy a template sheet to all other sheets except specific sheets to be excluded

    Hi all

    I am struggling with the following issue.

    I have an Excel wb with 90 timesheets for each employee and one master timesheet (named "Master").

    When the master timesheet is updated, i am trying to have a macro that copies this template to all the Employee tabs so they are identical.

    This is the easy bit, but i am having trouble with the following

    1. There are 4 sheets in the WB that I want to exclude from the Macro (named sheet1 , sheet2 etc)
    2. New Employees may be added (i.e. new sheets) that would need to be included.

    So basically, i am trying to create a Macro that copies and pastes the master sheet to all others, except specific sheets i want excluded.

    Can anyone help?

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: VBA to copy a template sheet to all other sheets except specific sheets to be excluded

    What are the exact names of the four sheets you want to exclude? Will the number of sheets that are to be excluded change or will it always be the same four?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    01-29-2015
    Location
    canterbury
    MS-Off Ver
    2010
    Posts
    3

    Re: VBA to copy a template sheet to all other sheets except specific sheets to be excluded

    Hi thanks for your reply.

    The 4 sheets are called

    List
    Summary
    Input
    Data

    These will not change.

    Many thanks

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,820

    Re: VBA to copy a template sheet to all other sheets except specific sheets to be excluded

    This macro will loop through all your sheets and exclude the ones you listed. I've also excluded the "Master" sheet since you wouldn't want to copy it to itself.
    Please Login or Register  to view this content.

+ 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 Template Sheet with Picture to all new sheets
    By guitarsweety in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2014, 11:34 AM
  2. Replies: 17
    Last Post: 02-01-2013, 12:20 PM
  3. Copy from sheet to other sheets, after each heading, in a specific row
    By sans in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2012, 03:03 PM
  4. [SOLVED] Copy All Visible Sheets To New Workbook Excluding Specific Sheets
    By ezrizer in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-19-2012, 02:19 PM
  5. Copy specific cell from multiple sheets to summary - excluding some sheets
    By kabammi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2012, 09:27 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