Using Excel 2003. I have created several drop down options using Validation
lists. My question is can I have the program autoselect several options from
other validation lists based on my selection of another validation list?

For example, I have drop down lists A, B, and C. Each with 3 selections.
So instead of changing Lists A, B, and C seperatly, can I have B, and C
automatically go to selection 2 when I select A2?

Hopefully that makes sense.