Hi all,

This is my first thread so please be gentle!!

I am creating a transport planning spread sheet utilizing dependent drop down lists.

One list containing Hauliers (Transport companies) the other containing Haulier specific route codes. I have used the "Indirect" data validation technique to ensure The relevant Route codes are selectable once the Haulier type has been chosen. My initial problem was that if the Haulier selection was changed at a later date the route code would then be incorrect.

After reading the following thread: http://www.excelforum.com/excel-prog...ult-value.html I was able to ensure the route list defaulted to blank if the haulier was changed. I achieved this by adding code to the specific sheet as described in the link.

This works great but I have multiple instances of this list arrangement and I’m struggling to work out the correct syntax of the vba code to cater for multiple lists/cells.

Example of code:

[Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A2") Then
Target.Offset(0, 1).Value = ""
End If

End Sub]

Any help is much appreciated

Thanks