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?