importing data

[Wee man]

I have data in roughly 500 different files which I would
like to place all on one sheet. Does anyone know an
easier method of doing this than having to go in and open
every file individually and copying and pasteing?

Thanx

 

[Paul B]

Wee man, have a look here http://www.rondebruin.nl/copy3.htm#sheet to get
them all in one workbook and then here http://www.rondebruin.nl/copy2.htm to
put them in one sheet

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **