I have Office 2003. I had something I wanted to do and am not sure if it is
even possible. If anybody knows how, please tell me. I'd greatly appreciate
any help I can get. What I want to do is to have one column in Excell be for
employee name and one be for the name of the supervisor. The employee column
should simply be a drop down menu where the user can select the employee from
a list of the employees in the office. Please let me know how to do this if
it is possible, but then please let me know if this is also possible, and how
to achieve it if so:

What I'd want when the user chooses an employee is for the supervisor column
to automatically be populated with the name of their supervisor. For example,
if Fred Krueger's supervisor is Mick Foley, when you select Fred in, say, row
2 of the sheet, it should automatically place Mick Foley in the supervisor
column of row 2 so that is shows him as Fred's supervisor for the entry.
After that, you should be able to select Neil Anderson in row 3 and have it
automatically enter his supervisor Ray Stantz in the supervisor column for
that row.

Once again, if anybody can help I would greatly appreciate it.

--
Have a nice day!

~Paul
Express Scripts,
Charting the future of pharmacy

~~~~~~
| |
|c--OD
| _)
| |
|-. |
/ `-# /A
/ /_|..`#.J/
||LJ `m''
ptaylor