Dear all, it will be a miracle if I can get an advice here. I am actually doing a shift-work roster for my job.
I'm finding ways for excel to automatically fetch the respective name of the employee right after choosing his/her shift via a drop box.
(e.g. For Tom, under the column of date, say 3 October, I rostered him under morning shift. Right after the action of choosing morning shift from the drop box, I want excel fetches the text "Tom" & copy and paste to another tab or spreadsheet. )
I think it will really take a miracle for someone in the Christian forum to answer me on this.
I will try it anyway, thanks in advanced for even reading my post.
I'm finding ways for excel to automatically fetch the respective name of the employee right after choosing his/her shift via a drop box.
(e.g. For Tom, under the column of date, say 3 October, I rostered him under morning shift. Right after the action of choosing morning shift from the drop box, I want excel fetches the text "Tom" & copy and paste to another tab or spreadsheet. )
I think it will really take a miracle for someone in the Christian forum to answer me on this.
I will try it anyway, thanks in advanced for even reading my post.