adding data from one sheet to another sheet as a dropdown list bo.

I want to add a drop-down list box on a seperate worksheet that my data is on

On this other sheet that holds your data, select the range that you want to
use in the Data Validation list and name it via Insert - Name - Define and
type in the name, like "MyList" without the quotes.
Then in the cell where you want the Data Validation cell, click Data
Validation, select List, and type "=MyList" without the quotes. Done. HTH
Otto
"gatorguy" <[email protected]> wrote in message
news:[email protected]...
>I want to add a drop-down list box on a seperate worksheet that my data is
>on
>