combining excel files

[RicM]

Hello,

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

any ideas ?

--
RicM

[Bart Snel]

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]

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


"Bart Snel" wrote:

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

[Ron de Bruin]

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"RicM" <[email protected]> wrote in message news:[email protected]...
> No Bart sorry.
> I want to add the rows of each file into a new file.
> --
> RicM
>
>
> "Bart Snel" wrote:
>
>> 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 ?
>>