+ Reply to Thread
Results 1 to 1 of 1

Work employee posting tracker/printable schedule help

  1. #1
    Registered User
    Join Date
    Flint, MI
    MS-Off Ver
    Excel 2007

    Work employee posting tracker/printable schedule help

    I have limited VBA knowledge and might have got in over my head but I'm sure it's not a difficult solution. Basically I spreadsheet (attached) that I created to track employee positions, future time off requests, their one 8 hour work day per 2 week pay period, ect.

    The problem is I need to find a way to use cell data from the "Matrix" tab to auto fill cells for a printable 2 week schedule ("7-19" has semi blank format I need used). Preferably I'd like to have a macro assigned to a button where I could click it, create a new worksheet labeled with the last day of the pay period for that 2 weeks, be able to print the 14 pages of that tab then somehow repeat the process every few weeks with newly inputted data.

    There is another worksheet labeled "Data" where I started to mess around with the info I wanted in the Data Validation list for the Matrix tab. If Employee 1 is scheduled to work "North County Radio" for that day, I'd like the name filled into the cell next to it. Also any employee not scheduled to work, at training, on vacation, ect would be listed in the "Pass Days" column for each day in the "July 19" tab.

    I'm not how well I did explaining that but would be happy with even a starting point to get this thing going. Any help would be appreciated.
    Attached Files Attached Files

+ 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. Formula to extract Employee work schedule report from "date of hiring list"
    By ravikiran in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-13-2010, 05:56 PM
  2. Employee Work Schedule
    By rdvarona in forum Excel General
    Replies: 1
    Last Post: 03-16-2010, 03:03 AM
  3. employee work schedule
    By rdvarona in forum Excel General
    Replies: 3
    Last Post: 03-14-2010, 11:30 AM
  4. Employee work schedule
    By rickc in forum Excel General
    Replies: 2
    Last Post: 04-18-2006, 08:46 PM
  5. Employee Work Schedule
    By nzatmj in forum Excel General
    Replies: 0
    Last Post: 10-21-2005, 04:34 PM


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