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" wrote in message ...
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" ha scritto nel messaggio
...
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" wrote in message
...
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