+ Reply to Thread
Results 1 to 2 of 2

Copy multiple filtered datasets to unique new workbooks

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Australia
    MS-Off Ver
    2013
    Posts
    1

    Copy multiple filtered datasets to unique new workbooks

    Hi All,

    I am new here and not overly familiar with macros and VBA code but have a long forgotten history in programming so I hope I will adjust quickly.

    I have a small problem with managing an ongoing master program of project works and fortnightly timesheets for 10 project managers (PMs). I have searched the forums and the web and while there are undoubtedly solutions out there, I have not managed to find one that does what I need or is close enough for my limited understanding to adapt.

    I would like to generate, using a macro, a separate fortnightly timesheet workbook for each of the 10 PMs, populated with data from a master program workbook. The master program has the list of projects and the name of the PM who is assigned to the project.

    Ideally I would click a button, be prompted for the 'fortnight ending' date and then the macro would parse the entire program list and spit out 10 timesheet workbooks populated with only the project details for each PM.

    The attached two workbooks show the key data from the master spreadsheet (there is a whole lot of additional info that I have stripped out as it is not required for this example) and a sample timesheet template.

    I am after something that will effectively filter by PM in column C of the master sheet and then populate a timesheet template for each unique PM in the format provided from row 4A.

    The timesheet should be saved with a unique name (Maybe <PM Name> Timesheet <Period ending date>.xlsx)

    I need to do this as over time the PM assigned to a project changes or projects are added or removed in the master list. As a result the timesheets need to vary over time.

    Any help or direction to similar macros or code would be appreciated.

    Thanks for your time.

    Matt
    Attached Files Attached Files
    Last edited by Mathos; 10-07-2014 at 10:05 PM. Reason: Change Title

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,307

    Re: Create Multiple Timesheet Workbooks from master project workbook

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Ben Van Johnson

+ 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. Create and Label Multiple Workbooks Using Data From Master Workbook
    By ChrisAnthony in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-23-2013, 11:07 AM
  2. Same multiple workbooks and a master workbook.
    By rlph7044 in forum Excel General
    Replies: 2
    Last Post: 05-11-2012, 02:22 PM
  3. Multiple Workbooks to one 'Master Workbook'
    By hammer2 in forum Excel General
    Replies: 4
    Last Post: 03-24-2012, 05:04 AM
  4. Macro to create new workbooks from master workbook
    By el_pasmado in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-30-2008, 07:31 AM

Tags for this Thread

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