Hi,
Looking for a bit of help with my shift rota spreadsheet. On the Schedule part of the sheet I choose the names of people doing the shifts and there hours are auto calculated on employee hours page.
However what im looking to do is have an auto look up on Shifts by name page where it looks to the schedule and pulls over the data to the corresponding name, ie shift and time.
I have attached the spreadsheet to this thread any help is appreciated.
Thanks in adavanceView attachment NEW DUTY SHEET 06052011 (Autosaved).xls
Looking for a bit of help with my shift rota spreadsheet. On the Schedule part of the sheet I choose the names of people doing the shifts and there hours are auto calculated on employee hours page.
However what im looking to do is have an auto look up on Shifts by name page where it looks to the schedule and pulls over the data to the corresponding name, ie shift and time.
I have attached the spreadsheet to this thread any help is appreciated.
Thanks in adavanceView attachment NEW DUTY SHEET 06052011 (Autosaved).xls