This seems like something that should be simple, but I can't figure it
out.

I have an excel spreadsheet being used as a time sheet. I am using drop
down lists to select a job code using lists and data validation.

However, I would like to set up a drop down list where when a user
selects the description for a job code, it automatically places the job
code in the drop down cell.

for instance: Let's say I have two lists side by side. The first list
is descriptions (Holiday) and the second list is codes (PX1430.) I
would like a drop down list so when a user selects "Holday" it
automatically put the code in the cell.

How is this possible?


--
chriscana
------------------------------------------------------------------------
chriscana's Profile: http://www.excelforum.com/member.php...o&userid=32643
View this thread: http://www.excelforum.com/showthread...hreadid=524485