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
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