Creating a internal phone book for a company.
Sheet 1 has the following details:
Division
Department A
employee 1 123456
employee X 123457
employee 3 123458

Department B
employee 2 987654
employee Y 987653
employee Z 987652
etc.

Sheet 2 is an alphabetical listing of all employees, regardless of which
dept. they work in.
My question is how can I get excel to automatically add the section they
work in after the other details ie:
employee 1 123456, Department A
employee 2 987654, Department B
employee 3 123458, Department A
employee X 123457, Department A
etc.
--
tia