adding staff according to time

[B4L4KS]

hi

i have a problem where i need to add a staff member to a cell but according to a time scale between 6-14, also i then need it to switch to another staff member to carry on between 14-22,

this is the staff sheet, i need from table A the first name and from table B the first name also, A before B please,

many thanks

kristian

 

[GlennUK]

Is this a duplicate post?

http://www.mrexcel.com/forum/showthread.php?t=534679

... although I still think that your request is not clear.

 

[B4L4KS]

hi

sort of no one answered last time but it is different to the last.

i need a staff member to be in a cell between 6-14 hours then swap to another between 14-22

eg, alan in shift A will appear between 6-14 and swap to shift B so amid will appear

thanks

kristian