HI Have Greeting to all member My self Alok I have some issue there some data which are in Aug July-----Jan(Execute Sheet) and I have data in Jan feb------Aug but I want ot paste is in my execute sheet please suggest me
I hope ASAP Thanks Ragard Alok Dbs -----Original Message----- From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of A.A.A Sent: Wednesday, September 03, 2008 5:08 PM To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ merging to different sheets 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---