Hi,

Have tried but no luck. I have 20 dropdown lists all connected to this other workbook and when I insert a new line the dropdown list I am doing it for is OK but all of the other drop down lists start to pick up the location of the worksheet it is on.

Any other suggestion I can try?