Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Copy&paste of several sheets

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.




  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default Copy&paste of several sheets

Please post in one group Lorenz

See your other thread

--

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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy cells from one worksheet and paste to incrementing sheets? [email protected] Excel Discussion (Misc queries) 2 February 19th 07 12:35 PM
Auto "copy and paste" individual cells from various sheets into one sheet ?? [email protected] Excel Discussion (Misc queries) 2 March 1st 06 04:19 AM
Copy-Paste sheets - error in the dates Aninha Excel Worksheet Functions 1 February 28th 06 05:04 PM
copy from one sheet and paste into other sheets TUNGANA KURMA RAJU Excel Discussion (Misc queries) 3 December 8th 05 03:49 PM
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? Daniel Excel Worksheet Functions 1 July 6th 05 09:57 PM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"