| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from multiple excel files in one folder
I have a set of sequentially numbered files (starting at 1000.xls) in a main
folder that contains subfolders. I want to import data from certain fields, with a new row for each file. I currently am using: ='P:\Folder 1\Main Folder\subfolder\[1002.xls]POForm1'!$L$1 to link to the data I want, modifying the file number by hand to update the file. I have 32 different pieces of data that I am pulling from each file, along with 6200 files and counting..... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open many *.tsv files in folder and import the data into Excel | Excel Programming | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Discussion (Misc queries) | |||
| how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder? | Excel Programming | |||
| Import data from multiple excel files | Excel Programming | |||
| Excel VBA - Import Data for manipulation from multiple text files | Excel Programming | |||
Threaded Mode
