Name Selection in a userform, To create a Signing In Sheet.

Hi there,

Im new at this, i hope ive given enough information to explain what im wanting to atcheave.

I am creating a yearly rota that will produce a signing in sheet on a day and night basis. Im using a userform to pick the... Department, Operators name, Time In & Time Out.

I would like the dropdown box in my user form to only show the operators that are on shift that day/night. to reduce the chance of selecting an operator that isnt even on shift.

I would also like it to subtract the names after the have been selected. to reduce the chance of entering the same name twice in the same sheet.


Can anyone help me please!!!

Oh... I see it now thanks for that.