Drop list and redirect

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.....

I may not have a full grasp of what you want to do, but this is what came to
mind.

Name the list in W1 and in the W2 valadation drop down source box enter
=ThatName.

HTH
Regards,
Howard

"WT" wrote in message
...
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.....