Hi,

I have a drop down list on one sheet which looks at a list of peoples names on another worksheet, when I add a line in this sheet to add another name the list then searches on the worksheet it is on.

For example

Worksheet 1 Worksheet 2

Dropdown list List of names (A1:A50)

Once I add a name to the list it searches A1:A50 on worksheet 1

Any ideas what is happening on this ?

Thanks