Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data from multiple excel files
I have been given 19,000 seperate excel files, each has the data laid out it
the same way, but i need to get only a few selected pieces of data from all of them into one file, i though about a macro, but it only seems to work for the file i created it in, and i had some issues with information being repeatedly pasted once the data had been moved, anyone got any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data from multiple excel files
I think you will have to use a macro if you have 19,000 files!!
Generally, you can have a master file which contains the macro, and the macro will open each of your other files in turn and then copy the appropriate data to the next available row(s) in the master file, then close the file and move on to the next one. At the end of it you will have all the relevant data within the master file. Hope this helps. Pete On Apr 20, 11:46 am, chewy wrote: I have been given 19,000 seperate excel files, each has the data laid out it the same way, but i need to get only a few selected pieces of data from all of them into one file, i though about a macro, but it only seems to work for the file i created it in, and i had some issues with information being repeatedly pasted once the data had been moved, anyone got any suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing data from multiple excel files
Try this chewy
http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "chewy" wrote in message ... I have been given 19,000 seperate excel files, each has the data laid out it the same way, but i need to get only a few selected pieces of data from all of them into one file, i though about a macro, but it only seems to work for the file i created it in, and i had some issues with information being repeatedly pasted once the data had been moved, anyone got any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing multiple files | Excel Discussion (Misc queries) | |||
Importing multiple files | Excel Discussion (Misc queries) | |||
importing multiple .dat files! | Excel Worksheet Functions | |||
Importing from multiple Excel files | Excel Discussion (Misc queries) | |||
Importing multiple Text files into Excel 2003 | Excel Discussion (Misc queries) |