+ Reply to Thread
Results 1 to 1 of 1

Make a rolling schedule that repeat itself when one turn is made.

  1. #1
    Registered User
    Join Date
    11-24-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    2

    Make a rolling schedule that repeat itself when one turn is made.

    Ok I am gonna try to make myself understood in my poor english

    Fist of all i have micro skills in macro and i have so far only succeded with one small thing.

    What i want to do is to make and schedule in excel 2010.
    - It will have five days.
    - 21 different posts/stations (work posts/stations). So it is 21 employees.

    For example, if employee nr1 is on station 1 on monday it will be on station two on tuesday etc untill
    friday where it will be on station 5.
    I want to make a macro that by pressing on the "scroll bar" button up, it will go to next week.
    So employee nr 1 jumps down to station 6 on monday, station 7 on tuesday etc.

    This is possible to make the problem comes to when the employees pass by station 21, because then they should
    go up to station 1.

    What i am trying to explain is that i want to make a macro that everytime i press on it, it will take down the person
    5 steps, something like this:

    WEEK1
    mon tue wed thur friday

    stat1 Alf
    stat2 Alf
    stat3 Alf
    stat4 Alf
    stat5 Alf
    WEEK2
    stat6 Alf
    stat7 Alf
    stat8 Alf
    stat9 Alf
    stat10 Alf

    Of course the schedule is packed with the other employees during week 1 and 2 etc so i only want one schedule but that it jump down everytime i press the up button and i ALSO want to be able to go back, with the scroll back button..

    I know that this isnt a easy task, not for me at least and i really apriciate all the help i coud get. I am really a novice in this so hopefully someone can help me in the "same" langauge hehe.

    Ps. Want to make the week number to change everytime i change of week also.

    Best regards
    a new macro fantast


    PS linked a example since the example i tried to show here didnt work so good when the words were rearrenged.
    So when you look at the example then i want it to go around and around and every time the "NEW WEEK" button is pressed then the week number goes up... also to make an reverse button so i can see the weeks before.
    Attached Files Attached Files
    Last edited by Kristian Nilsson; 11-24-2012 at 02:34 PM. Reason: posted a link

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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