It may take a little work, but it shouldn't be too bad:
http://www.contextures.com/xlDataVal02.html

You should learn some new things in the process...

Regards,
Ryan--

--
RyGuy


"Hal" wrote:

Hello,

I have a question regarding dropdown lists in Excel. I would like to
dynamically link 4 drop down lists together each list contains 4 values.
When I select the first value in list number 1 I want Excel to auto select
the first value in the other lists as well and so on for the other values.

For example, the lists in question are in columns AP, AQ, AU, AV the source
table for the list is found K223.

Thank you in advance.

Hal.