EXCEL MISSION IMPOSSIBLE ?

[hkappleorange]

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 in a single new workbook with
these 3 fields containing
all data from these 200 tables.

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

 

[Anne Troy]

Try these two macros:
http://vbaexpress.com/kb/getarticle.php?kb_id=221
http://vbaexpress.com/kb/getarticle.php?kb_id=151
************
Anne Troy
www.OfficeArticles.com

 

[Norman Jones]

Hi HKappleorange,

When you posted the identical question in Misc, did none of the seven
responses assist you?

If your problem is a lack of familiarity with macros, you may wish to visit
David McRitchie's 'Getting Started With Macros And User Defined Functions'
at:

http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[aaron.kempf]

dude throw excel away and use a database

 

[Ron de Bruin]

Very easy to do with the link I and Dave posted it your other thread

Have you try it ?