Staff Allocation - User form VBA codes to avoid double booked

[hsolanki]

Hi everyone

i really need an expert help with my intention if if any can help me get the right vba coding.

i am not an expert on VBA codes and i have learnt from videos such as youtube and also from PClearning from which i have created same a Staff Allocator data sheet

basically i want an coding with existing coding that helps allocate staff on the job as per queing system and once "Booked" on the Job cannot book him again on Job and can only book once you make them "available" for example;

if John, Steve, Bates, Cain, Clarke and Bowers are the staff for the day will all be "Available" to do a job and once "John" has been allocated a Job then John should NOT be allowed to Book him on a job and if tried to Book him then msgbox should show that John is already allocated on the Job.

once the John complete his Job and comes back to base to be allocated again then he should go in to Que as the last person behind "Bowers" and cannot book him on the job until his turn come up.

i would be really grateful if anybody could potentially help with my intention of similar to my ideas.

also how do i upload a file in here?

i look forward to hear from some of the expert

Thank you all in advance.

 

[hsolanki]

Hi can anybody write VBA code or similar for my intention projects.

i send you over an my existing project.