Posted to microsoft.public.excel.newusers
|
|
Making a drop down list read info from another tab / worksheet
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
|