Originally Posted by macropod

In order to do that, you would need to have a complete list of pupils and their teachers stored somewhere (e.g. a table in a Word document, an Excel worksheet, an Access database) for a macro attached to the dropdown to access. Do you have such a list?