G
gramps
This maybe quite simple but I seem to be getting into quite a state.
I have a workbook comprising of 2 worksheets;-
#1 – “rosterâ€
#2 - “myrotaâ€
The first compiles a roster for the 16 man department for the coming week
and is compiled automatically on entering the w/c date using a VLookup list.
What I want to do on “myrota†is to enable any member of the department to
enter their name which gets looked up in the “roster†and get a list of their
duties for the next 16 weeks.
I’m not sure whether I have given all the information you need to help but
any assistance would be greatly appreciated.
I have a workbook comprising of 2 worksheets;-
#1 – “rosterâ€
#2 - “myrotaâ€
The first compiles a roster for the 16 man department for the coming week
and is compiled automatically on entering the w/c date using a VLookup list.
What I want to do on “myrota†is to enable any member of the department to
enter their name which gets looked up in the “roster†and get a list of their
duties for the next 16 weeks.
I’m not sure whether I have given all the information you need to help but
any assistance would be greatly appreciated.