Macros in Excel

[alhawtin]

How can i create a macro that changes what is in a drop down box by what is
selected in another dropdown box?

 

[JE McGimpsey]

You could record a macro of your changing the validation list.

However, you can do it without a macro using the technique here:

http://contextures.com/xlDataVal02.html