Drop list and redirect

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

L. Howard Kittle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top