Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to import data from many several workbooks
I recently designed a data collection tool sent out to reps around the
country. Each rep was instructed to save their file with his/her State abbreviation and send it back to me. So that means i have 50 files (1 for each abbrev). I need to pull all the data entered into one workbook that lists all the States (each row contains the State Abbreviation in column A and to the right of column A is all the fields from the data collection tool)... What would be the best way of going about doing this? I am assuming there has to be some kind of database query or something along those lines, just that I am not to familiar with any feature like this. I tried using indirect.ext, but it only works for one cell at a time. When I drag it down to other cells, it crashes excel everytime. Can someone point me in the right direction? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Data | Excel Worksheet Functions | |||
Macro that will add data from multiple workbooks to the 1st open r | Excel Discussion (Misc queries) | |||
import external data from changing file name | Excel Worksheet Functions | |||
Import Data: on insert, shift data down and not right | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |