Change data validation dropdown list using radio buttons

Hello Everyone,


I'm having a problem with data validation drop down lists.

I'm making a degree audit sheet in Excel. I have a radio button on the degree audit sheet with two choices: A.A. and A.S.

I have data validation drop down lists for classes in physical science and life science which need to change depending on which degree option is selected via radio button.

The course information for both sciences are stored in separate tables on a different sheet, two tables for the physical and life science requirements for the A.A., and two tables for the physical and life science requirements for the A.S. Each table has two columns: one column with course ID numbers, the other with credit amounts.

When the radio button for A.A. is selected, I need the drop down lists for physical science and life science, located on the degree audit sheet, to display the corresponding course names from the A.A. tables, located on a separate sheet (I get the credits via index-match). When the A.S. radio button is selected, I need the course name lists to change to the corresponding A.S. tables (credits are obtained through index-match, as before). The course names are saved as named ranges, and the tables themselves all have unique names.

Any help much appreciated!
David

Can you use the radiobuttons to feed Data Validation an INDIRECT reference? That might be easiest if your particular setup supports it.