Quote:
Originally Posted by jeffk
I know how to create a data validation drop-down list that references data in another workbook..........is it possible to do it with data from a non-spreadsheet file e.g word or access & if so how do I do so?
|
Just to be clear - I know I can import data from non-spreadsheet external sources, but that seems to just put the data into visible cells, it's
how to use it in a drop down list that I'm asking for help with.
Thanks