I have two workbooks W1 and W2, they both contain the same columns with the
same type of data. I know how to have W2 display the changed cell when W1 is
updated, however I would also like to add a validation list for W2 in the
same cell. The list contains the same values as those entered in W1. Is there
any way to put the validation drop list and a redirect in the same cell and
if so how???

Your ever greatful student.....