Employee Absence Cover Rota

JOONA

New member
Joined
Dec 9, 2013
Messages
27
Reaction score
0
Points
0
Hi I am trying to create a excell spread sheet or group of spread sheets to create an engineer checklist, this check list is broken down into 22+ branches each with there own set of engineer.

The branch sheets allow us to add which engineer is off and wich engineer is covering etc. however this is where i get stuck as i have limited knowledge.

I need a search screen page to allow me to enter the engineer ID i then press search, this then searches through all of the work books to find the engineer number that I have just enetered to return the following details.

branch he works for branch contact details engineer that is off why he is off who is covering etc.

can anyone help with this.

I have done one sheet for now

Your help will be much apreciaited
 

Attachments

  • test.xlsx
    12.9 KB · Views: 14
Top