+ Reply to Thread
Results 1 to 4 of 4

VBA - Changing Roster Vaules

  1. #1
    Registered User
    Join Date
    03-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    VBA - Changing Roster Vaules

    Hi All,

    I have a roster for the whole year that consists of 4 teams (2 each team). When a staff member takes rec leave, another staff covers him while his away. This means that have staff needs to swap "lines" then return to his line. At the moment I manually enter the days his swaps line and make the adjustments accordingly. For this example, I have manually updated the roster to show you (these updates are in RED).

    Each team has a specific color, to visually see if all shifts are covered. Min 2 per day. I will use conditional formatting for this.

    Using VBA, is there a way to do the line swaps automatically?

    I appreciate if someone could help me.

    I have attached a sample.

    Many Thanks.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: VBA - Changing Roster Vaules

    *bump* *bump*

  3. #3
    Registered User
    Join Date
    03-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    Exclamation Re: VBA - Changing Roster Vaules

    Hi All,

    It's been awhile since last post. I had to revisit it and update it. I have been working on this and just need a little help on a line of code.

    When a employee goes on leave and a relief employee covers them, i would like the code to find the cell data in "Roster" sheet and put it to the relief employee name. The code below does do what I like it but at moment i have "SW" (shift swap) instead of the employee roster shift. How do I find the cell data in employee on leave from roster and and put it to relief employee?

    Please Login or Register  to view this content.
    The
    Please Login or Register  to view this content.
    is what I'm having problems with. Any help will be appreciated.

    Please see updated file.
    Attached Files Attached Files
    Last edited by Bloodywog; 08-14-2014 at 09:29 PM.

  4. #4
    Registered User
    Join Date
    03-10-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    79

    Re: VBA - Changing Roster Vaules

    All working.

    Please Login or Register  to view this content.
    Last edited by Bloodywog; 08-17-2014 at 03:25 AM. Reason: typo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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