Is it possible to import data from another source, eg text pad, to be part of
a dropdown list? Can this be done without having another worksheet in the
workbook?

Thank you very much, again

Hi, you can open the txt (or others) direct by excel, it will advice you that
this file is not an excel file format and will open a box with a lot of
options to import it.

import copy the range that you are looking for and paste it on the drop down
source area

HTH
Regards from Brazil
Marcelo


"sedonovan" escreveu:

Is it possible to import data from another source, eg text pad, to be part of
a dropdown list? Can this be done without having another worksheet in the
workbook?

Thank you very much, again