If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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..... |
#2
|
|||
|
|||
Drop list and redirect
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..... |
Thread Tools | |
Display Modes | |
|
|