+ Reply to Thread
Results 1 to 5 of 5

Split Schedule into separate sheets

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    399

    Split Schedule into separate sheets

    Hi there,

    So, I receive a schedule of meetings each month which could range from 30 to 100 rows.
    Within my demo spreadsheet, this sheet is called "Schedule" with the one training session across the columns.

    I need to create attendance sheets for each row on Schedule sheet.
    I want to copy the "SignSheet" move data from "Schedule" from each row to the new "SignSheet" to each yellow highlighted areas, name the sheet and move to the next row.
    Since I cannot have duplicate sheet names, I added column A with each sheet number to be used as sheet name.

    Once all sheets are made, I would like to print out all sheets all formatted as the original "SignSheet"
    I will then need to have a way to delete the previous month's sheets ready for the new month to begin the process again.
    I have googled some but I have not found any code that works close to what I want.

    Thanks
    Attached Files Attached Files
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    520

    Re: Split Schedule into separate sheets

    Please Login or Register  to view this content.

  3. #3
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    5,855

    Re: Split Schedule into separate sheets

    Please try

    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    399

    Re: Split Schedule into separate sheets

    Hello ikboy,

    Thanks for your solution to my question, it did work as requested, but it ended up deleting the first two sheets which was the sheets I wanted to keep.

  5. #5
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    399

    Re: Split Schedule into separate sheets

    Hello BO_RY,

    Thanks for your solution to my question, it did work as requested. I tried it on my real data and I am very happy with the results.
    It's good to see how others approach coding this, I have lots to learn!!
    Thanks

+ 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: 4
    Last Post: 01-21-2020, 12:42 PM
  2. Creating a macro to split data into separate workbooks and separate worksheets
    By jfish07 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-27-2019, 10:48 AM
  3. Advanced Filters to split data into separate sheets
    By mscarrie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-17-2019, 09:13 PM
  4. Split Data Into Separate Sheets REVISITED
    By Kmatten in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-19-2015, 11:58 AM
  5. Macro to Split Data into separate sheets
    By zahinullah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2013, 06:41 PM
  6. Macro to Split Data Onto Separate Sheets
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-20-2013, 11:02 AM
  7. [SOLVED] Need to split a LONG list into separate sheets based on repeating, incremental nunbers
    By matrix_machine in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2012, 04:37 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