Prev: Sharing workbook
Next: Logical Test for blank and then for score
From: WT on 30 Apr 2010 17:21
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.....
From: L. Howard Kittle on 30 Apr 2010 18:11
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" <WT(a)discussions.microsoft.com> wrote in message
news:140D6DEA-7EA5-400D-8E40-5EAD5338D9E7(a)microsoft.com...
>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.....


 | 
Pages: 1
Prev: Sharing workbook
Next: Logical Test for blank and then for score