+ Reply to Thread
Results 1 to 1 of 1

Excel VBA VLOOKUP, INDEX, dget, IF, Database

  1. #1
    Registered User
    Join Date
    08-22-2017
    Location
    Copenhagen, Denmark
    MS-Off Ver
    2003
    Posts
    1

    Lightbulb Excel VBA VLOOKUP, INDEX, dget, IF, Database

    I'm managing 24 guards on three guardteams, Team 1, 2 and 3.

    There are four locations, locations A, B, C, D, each occupied by a single guard.

    Common to the four guards is; That they can not be shared between two employees

    Location A starts and ends at 8 am, location B starts at 8am and ends at 2 pm (the day after), location C starts at 10 am and ends at 2 pm (the day after) and location D starts at 12 pm and ends at 4 pm (the day after)

    The three teams will thus turn: Day 1 coming on duty, Day 2 coming of duty, Day 3 day off, Day 1 coming on duty, and so on and so forth.

    Their schedule is fixed four months at a time with date in rows and their names in column (Sheet1-4, with month's denomination).

    Based on date and name, each person can see when he or she is assigned to a location.

    issues:

    1: I need it possible, in another sheet (Ark5), to enter the employees ID number, thus displaying the chronological order of location duties, that the employee is assigned for one month at a time.

    The requirement for the solution is as follows:

    - The schedule should appear in rows instead of columns, as in the example in Ark5.

    - Date, location and time of the relevant location must appear in each column.

    The example shows the desired end result, which I have manually entered.

    2: When the locations are to be roasted, weekends, number of duties and type of location must be taken into account equally. Is it possible to set up a function that, on the basis of the four locations, automatically fills in the optimal solution for how the four locations should be allocated to the 8 employees? I am thinking that it is necessary to indicate some variables, such as holiday, times of weekends, number of days a month etc.
    Last edited by Rubenlarsen; 08-22-2017 at 03:52 PM. Reason: add attachment

+ 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. dynamic, double vlookup, match, index, dget?? different workbooks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 09-06-2005, 12:05 PM
  2. dynamic, double vlookup, match, index, dget?? different workbooks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 09-06-2005, 07:05 AM
  3. dynamic, double vlookup, match, index, dget?? different workbooks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-06-2005, 06:05 AM
  4. dynamic, double vlookup, match, index, dget?? different workbooks
    By Bernie Deitrick in forum Excel Formulas & Functions
    Replies: 33
    Last Post: 09-06-2005, 04:05 AM
  5. dynamic, double vlookup, match, index, dget?? different workbooks
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] dynamic, double vlookup, match, index, dget?? different workbooks
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. dynamic, double vlookup, match, index, dget?? different workbooks
    By Leslie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. dynamic, double vlookup, match, index, dget?? different workbooks
    By Leslie in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 06-27-2005, 05:05 PM

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