Thanks. I have reciewed the code it is kinda difficult for me as I am not
familiar with codes ...

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