Defaults for Multiple Dependent Drop Down Lists in same Worksheet

I was able to find code to create a default for a dependent drop down list on another thread:
http://www.excelforum.com/excel-prog...down-list.html
However, I have a dependent drop down list in more than one column and don't know how to add an Or statement or If statement properly to duplicate what is occuring in the target column. Below is my code:

Please Login or Register  to view this content.

If I also want to duplicate this in cells D11 & D17, F11 & F17, etc., how would I do that?

Try this:

Please Login or Register  to view this content.