ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing Data for lists (https://www.excelbanter.com/excel-discussion-misc-queries/95432-importing-data-lists.html)

sedonovan

Importing Data for lists
 
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

Marcelo

Importing Data for lists
 
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



All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com