+ Reply to Thread
Results 1 to 4 of 4

Planning drivers on cars

  1. #1
    Registered User
    Join Date
    05-21-2019
    Location
    Duiven, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Planning drivers on cars

    Hi all,

    I am working with VBA for a short time now and have come to a problem I cant solve. I have drivers to schedule on cars. The amount of drivers is stationary and their availability i can produce with formula's but appointing them to a not fixed amount of cars (trips) is what I trying to figure out. Please, help.

    Knipsel.PNGplanning.xlsx

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Planning drivers on cars

    Hi,

    You don't need VBA

    L5 copied across and down

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    I think you have a typo. Week 3 Robert isn't mentioned on any day yet you show him as available
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    05-21-2019
    Location
    Duiven, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Re: Planning drivers on cars

    Hi Richard,

    Thank you very much. I still think VBA could be useful because the range of cars and available people is different every week.

    Robert isn't mentioned because I don't have a driving job for him that week. So I will have to find something else for him to do.

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Planning drivers on cars

    OK,

    Often the simplest way is to get VBA to populate a table like this with the formulae required

    Here's one way base on your layout. You may need to adjust the formula in the macro if your results are not in columns L:P

    Please Login or Register  to view this content.

+ 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. [SOLVED] List cars on the road
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-16-2018, 07:10 AM
  2. excel template for cars reservation
    By cristines in forum Excel General
    Replies: 2
    Last Post: 02-14-2017, 11:32 AM
  3. Using Excel to log hired cars
    By rossf1uk in forum Excel General
    Replies: 3
    Last Post: 05-06-2016, 07:40 PM
  4. Get existing cars from a list
    By Immortal2014 in forum Excel General
    Replies: 6
    Last Post: 04-29-2016, 04:27 PM
  5. [SOLVED] Auto fill last km of cars
    By Immortal2014 in forum Excel General
    Replies: 7
    Last Post: 04-28-2016, 12:16 PM
  6. [SOLVED] Avoid search with wild cars **
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-02-2014, 11:18 AM
  7. [SOLVED] customerfollowup for cars sales
    By joanne panzo in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 06-13-2006, 08:20 PM

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