Hi guys,
I'm working on a weekly staff rota for work and I would like to give each employee a "home" position to start with but for it to be changeable if needs be.
Eg. Mr. Smith works in accounts, his "home" position, but I might need him to cover in HR in the afternoon so would have to move him, make sense? I could then replace him in accounts with Mrs. Jones. - all using drop downs. It would just be good to have a value in the cell to start with
At the moment I am having to select each employee from a drop down that gets its data from a named range on a separate sheet. I'd just like to be able to place everyone in the first instance - giving the cell that they're placed in its default value.
Thanks.
I'm working on a weekly staff rota for work and I would like to give each employee a "home" position to start with but for it to be changeable if needs be.
Eg. Mr. Smith works in accounts, his "home" position, but I might need him to cover in HR in the afternoon so would have to move him, make sense? I could then replace him in accounts with Mrs. Jones. - all using drop downs. It would just be good to have a value in the cell to start with
At the moment I am having to select each employee from a drop down that gets its data from a named range on a separate sheet. I'd just like to be able to place everyone in the first instance - giving the cell that they're placed in its default value.
Thanks.
