Drop Down List

[Vincent Kerzman]

I am trying to create a drop down list using two worksheets. How would I
create this.

One sheet would where the final product is and the other would be where the
data is being kept.

 

[T. Valko]

Watch this 5 min video:

How to setup a data validation drop down list:

 

[Vincent Kerzman]

Thank you for your help..I knew it was very simple.

 

[T. Valko]

You're welcome. Thanks for the feedback!