Hello
I am new to this forum but i need help already
I have a big excel file with schedule for drivers. car fleet nr, and days
In one row there are weeknr , row below the date , row blow dat the daynames.
than Collum A is driver
Now i have filled the rest with the carfleet nr or AG
Driver have 3 options
-Saturday / Sunday they change
1 - They stay driving (same car on Saturday and Sunday)
2 - They Start driving (Saturday AG, and Sunday Carnr)
3 - Thy Stop driving ( Saturday has Carnr , and Sunday AG)
example of 1 week
Driver 1 Car1 Car1 Car1 Car1 Car1 Car1 Car1 AAG
Driver 2 AG AG AG AG AG AG AG Car 1
Driver 3 Car2 Car2 Car2 Car2 Car2 Car2 Car2 Car2
on a other sheet user enters a weeknr , and button , than it generates a list below this button on that sheet a list that selects and short driver based on the end (Saturday / Sunday ) of that week
STAY STOP START FREE SICK
DRIVER3 DRIVER1 DRIVER2
Of course i have more than 3 drivers , an i have 5 states
STAY , STOP, START, FREE, SICK
everytime a user change weeknr this list so renew
this very hard one i know, i tryed alot of option ith lookup / index / match etc
any help is welcome with this challenging task
Greets John
Bookmarks