Hello everybody

first of all I have to say that I am not expert in the macro programming
with Excel.
I have the following problem.
I have an excel file containing about 200 sheets with the same structure
that I need
to copy and paste in one only sheet of another file.
To make an example, you can imagine that I have an excel file with about 200
sheets
corresponding to the several subsidiaries of a company and each one
containing
all the sales records done in a year.
Now my goal is to create automatically a new excel file containing the
content of all the 200 sheets,
without to do it manually by a copy&paste.
Do you have a solution or a tool that could help me ?

Thanx a lot.

Hi Lorenz

Try the example code on this page
http://www.rondebruin.nl/copy2.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Lorenz" <(E-Mail Removed)> wrote in message news:465c94f3$0$16036$(E-Mail Removed)...
> Hello everybody
>
> first of all I have to say that I am not expert in the macro programming
> with Excel.
> I have the following problem.
> I have an excel file containing about 200 sheets with the same structure
> that I need
> to copy and paste in one only sheet of another file.
> To make an example, you can imagine that I have an excel file with about 200
> sheets
> corresponding to the several subsidiaries of a company and each one
> containing
> all the sales records done in a year.
> Now my goal is to create automatically a new excel file containing the
> content of all the 200 sheets,
> without to do it manually by a copy&paste.
> Do you have a solution or a tool that could help me ?
>
> Thanx a lot.
>
>
>

Hi

thanks a lot for your very quick answer !


"Ron de Bruin" <(E-Mail Removed)> ha scritto nel messaggio
news:(E-Mail Removed)...
> Hi Lorenz
>
> Try the example code on this page
> http://www.rondebruin.nl/copy2.htm
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Lorenz" <(E-Mail Removed)> wrote in message
> news:465c94f3$0$16036$(E-Mail Removed)...
>> Hello everybody
>>
>> first of all I have to say that I am not expert in the macro programming
>> with Excel.
>> I have the following problem.
>> I have an excel file containing about 200 sheets with the same structure
>> that I need
>> to copy and paste in one only sheet of another file.
>> To make an example, you can imagine that I have an excel file with about
>> 200 sheets
>> corresponding to the several subsidiaries of a company and each one
>> containing
>> all the sales records done in a year.
>> Now my goal is to create automatically a new excel file containing the
>> content of all the 200 sheets,
>> without to do it manually by a copy&paste.
>> Do you have a solution or a tool that could help me ?
>>
>> Thanx a lot.
>>
>>

This was very useful, thank a ton !!

Sharad Sharma