Glad I could help, thanks for the feedback

"Paul" wrote:

Thanks Ron,

It works great!

Paul

"Ron@Buy" wrote:

See:
http://www.dailydoseofexcel.com/arch...#comment-34646

under heading Conditional data validation

Hope this helps

"Paul" wrote:

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