Drop list and redirect

  • Thread starter Thread starter WT
  • Start date Start date
W

WT

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
 
Back
Top