combining excel files

RicM · Jan 5, 2006

Hello,

I have 52 (week) identical excel files
I want them to combine them without to use copy and past.

any ideas ?

Bart Snel · Jan 5, 2006

RicM schreef:

Hello,

I have 52 (week) identical excel files
I want them to combine them without to use copy and past.

any ideas ?

Are you familiar with Data > Consolidate ?

RicM · Jan 6, 2006

No Bart sorry.
I want to add the rows of each file into a new file.

Ron de Bruin · Jan 6, 2006