Making a drop down list read info from another tab / worksheet

[Paul]

Hi All,

Would anyone know if it's possible to read info into a drop down from a list
in another tab in a spreadsheet - and if so how to do it?

I'm not sure if this is possible, but one of my managers is sure it can be
done easily.

Rgds,

Paul

 

[Ron@Buy]

See:
http://www.dailydoseofexcel.com/archives/2004/05/11/conditional-data-validation/#comment-34646

under heading Conditional data validation

Hope this helps

 

[Roger Govier]

Hi Paul

take a look at Debra Dalgleish's site.
It contains all the information you want about Data validation
http://www.contextures.com/xlDataVal01.html

 

[Paul]

Thanks Ron,

It works great!

Paul

See:
http://www.dailydoseofexcel.com/archives/2004/05/11/conditional-data-validation/#comment-34646

under heading Conditional data validation

Hope this helps

 

[Ron@Buy]

Glad I could help, thanks for the feedback

Thanks Ron,

It works great!

Paul