Employee shifts organization

[ALEZI]

Hello all,

I have problem to organize employee shifts in departments,

all employee on the list "Free Employee",according this list i organize them in different department,

when worker doesn't active i need move him to free employee column,

i can't explain thru the formulas what i want,i attached Sample file where i tried to explain.

Thank you in advance.

[azumi]

Maybe something like this? Still need for Referenced Table for All Names

Cheers

Azumi

[ALEZI]

Thank you ,it works fine..