Need to Consolidate Different Ecel files into one

[Keith]

Good Morning,

I have about 25 diffrent workbooks that are all formtted
the same and I want to add the data between the workbooks
to roll up into on workbook. Is this possible. I know I
can open all the work books and manually do this, but I
need a quicker way since I have a deadline to meet, Any
suggestions?

Thanks

 

[Ron de Bruin]

Try this Keith
http://www.rondebruin.nl/copy3.htm

 

[Keith]

Sir,

I have several different files that I want to combined,
they are not in the same workbook. Any thoughts?

Thanks,

Keith

 

[Ron de Bruin]

I have several different files that I want to combined,

they are not in the same workbook. Any thoughts?

I don't understand you.
What do you mean by this ?

Do you mean that they are not in the same folder ??

 

[Myrna Larson]

Have you tried Data/Consolidation? Read more about it in Help.