Drop Down List
 

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.

Drop Down List
 

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Vincent Kerzman" <Vincent wrote in
message ...
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.

Drop Down List
 

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


"T. Valko" wrote:

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Vincent Kerzman" <Vincent wrote in
message ...
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.

Drop Down List
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Vincent Kerzman" wrote in
message ...
Thank you for your help..I knew it was very simple.
--
Vincent Kerzman


"T. Valko" wrote:

Watch this 5 min video:

How to setup a data validation drop down list:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Vincent Kerzman" <Vincent wrote in
message ...
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.