Hi all
Please help....
I have a roster which is to be made out everyday, in cols D and I have drop down lists with staff names. When a staff members name is chosen say in D10 the corresponding name on the list in col M is highlighted to show it has been used on the roster.
My question is, when I choose a staff member I have to manually insert their start finish times beside their name in cols E and J. Is there a way to automatically paste what ever start finish times are beside their names in col N i.e Patricia Phillips entered in D11 and the times of 1300-2200 automatically pasted into E11.
If anyone could help me with this I could probably be home earlier for a beer.
Thanks
Bookmarks