I'm having a problem with dependent drop down lists. On the internet there are a bunch of examples, but each example has the data column right next to the dependent list. In my use of dependent drop-down lists my independent list is in column D and my dependent list is in column F. Can someone show me how to create the dependent list which isn't adjacent to the independent list?