Maybe you could use some code from Ron de Bruin:

http://www.rondebruin.nl/copy3.htm



hkappleorange wrote:

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.....

--

Dave Peterson