+ Reply to Thread
Results 1 to 2 of 2

Creating Multiple Worksheets from a Template and Separate Data Set

  1. #1
    Registered User
    Join Date
    04-03-2014
    Location
    Oahu, HI
    MS-Off Ver
    2010
    Posts
    2

    Creating Multiple Worksheets from a Template and Separate Data Set

    I have attached a copy of what I am trying to do, but I'll also explain it in words here.

    I have information on a Worksheet called 'Schedule' in two columns.
    I have a Worksheet called 'Template' that I want to copy to new Worksheets, rename those Worksheets, and fill in data from 'Schedule' when I click on a button.
    Additionally, once I have the new Worksheets created, I want to populate a 'Master Calendar' Worksheet that looks across all other Worksheets and puts the data in chronological order.

    I have attached an example. The data source is the 'Schedule'.

    Thanks in advance for any help. I am an extreme novice so any help is appreciated.

    Excel Help.xlsx

  2. #2
    Registered User
    Join Date
    04-03-2014
    Location
    Oahu, HI
    MS-Off Ver
    2010
    Posts
    2

    Re: Creating Multiple Worksheets from a Template and Separate Data Set

    Bumping back to the top to see if anyone can help. I appreciate any support on this.

+ 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: 2
    Last Post: 02-14-2014, 01:39 PM
  2. Replies: 1
    Last Post: 01-17-2014, 09:52 PM
  3. creating new worksheets from a template for each row of data
    By So_much_to_learn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-07-2012, 02:39 PM
  4. Separate monthly data to multiple worksheets
    By Nashvillbill in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 03-21-2007, 02:55 PM
  5. Replies: 1
    Last Post: 08-10-2006, 02:53 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