U need to write the macro in a compile sheet in followint sequence:
1. Have two lists in compiler sheet with names of those 2 x 300 books in two
columns together (say A1 for datas1, B1 for datag1, A2 for datas2, B2 for
datag2...)
2. Write a for next loop to pick values for those files:
For r = 1 to 300
=============Now right a code to perform following action=========
Cell(r,1) for datas1, Cell(r,2) for datag1
CODE to open and datas1 and datag1 and a new workbook (Workbook.add)
Copy sheets from both the workbooks to new workbook,
Save and close new workbook as data1
Close datas1 and datag1
=============Now right a code to perform following action=========
Next r
Did you get it?
Make sure screenupdating is turned off..
_________________________________________________________________________________________________
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things that we know we don't know. But
there are also unknown unknowns. There are things we don't know we don't know."
--- On Wed, 3/9/08, A.A.A <[EMAIL PROTECTED]> wrote:
From: A.A.A <[EMAIL PROTECTED]>
Subject: $$Excel-Macros$$ merging to different sheets
To: "MS Excel & VBA Macros" <excel-macros@googlegroups.com>
Date: Wednesday, 3 September, 2008, 5:07 PM
Hi,
I have 300 excel files and another different 300. I want to merge one
from the first 300 to one from the other 300,so that i will end up by
300 excel files each having 2 sheets one for the data from the first
300 files and the second sheet carrying the data from the other 300.
Is this possible?If possible, could you explain the steps as i am new
with the excel macros?
My files are named like the following:
first 300: datas1,datas2,datas3,.....datas300
Second 300: datag1,datag2,datag3,.....datag300
and I want to have 300 files each consisting of 2 sheets :
data1,data2,data3,...data300
so that data1 consists of 2 sheets the first is for the data of datas1
and the second is for the data of datag1
data2 consists of 2 sheets the first is for the data of
datas2 and the second is for the data of datag2
and so on.........................................................
Aya
Unlimited freedom, unlimited storage. Get it now, on
http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
