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?

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?

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?