Using a drop down for data validation from another sheet

[jeffcia]

Hi Guys,

I have a sheet named "Mileage Defaults", and in the first column I have a header (field name), "Location". I also selected the whole column including the column name and named the list "Location" as well.

On another sheet, I want to only allow locations that have been defined in that list, but I'm not sure how to reference that. I tried just typing in "Location" in the Data Validation Source, but now my dropdown only contains one item, "Location".

Any suggestions on referencing my list?

Thanks

 

[pedie]

Please check this link

 

[T. Valko]

Hi Guys,

I have a sheet named "Mileage Defaults", and in the first column I have a header (field name), "Location". I also selected the whole column including the column name and named the list "Location" as well.

On another sheet, I want to only allow locations that have been defined in that list, but I'm not sure how to reference that. I tried just typing in "Location" in the Data Validation Source, but now my dropdown only contains one item, "Location".

Any suggestions on referencing my list?

Thanks

See if these videos help:

How to setup a data validation drop down list

Excel versions 2003 and earlier

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

Excel versions 2007 and later

http://www.youtube.com/watch?v=fI7XCv07AAg

 

[danzon]

in data validation select

Allow List

in the Source box enter

=Location

 

[jeffcia]

Thanks! I left out the = in the source, so it thought I was defining a one-item list.