Have you try the link that Dave posted ?
http://www.rondebruin.nl/copy3.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"hkappleorange" wrote in message ...
Thanks all of you, but the data is in the form of 200 separate tables in 200
separate files.

"hkappleorange" ¼¶¼g©ó¶l¥ó·s»D
...
I have a simple task on Excel but I cannot figure it out. Pls help:-

I have 200 separate Excel files with data all in 3 columns: Region, Month
&
Amount. They each has a range of records from 100 to 300 lines each.

I am asked to create a single 3 column table with these 3 fields
containing
all data from these 200 tables in separate files.

How many ways we can do this ? Please help.....