as mentioned in some of my previous queries i work for an accident management
company. as part of my job i need to instruct independant engineers to carry
out inspections. in order to do this i need an excel database kinda thing
where i key in the name of the bodyshop or a postcode and it shows me the
engineers i need to instruct. my question is how do i configure an excel
spreadsheet to do this task i have all the postcodes that each engineer
covers and i know this can be done because our call centre has a similar file
where they key in a postcode and it says what bodyshop to allocate it to with
a 1st 2nd 3rd and 4th choice. so if someone can tell me how to do this id be
most grateful.
--
Stuart