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