$$Excel-Macros$$ Re: merging to different sheets

2008-09-18 Thread alok ranjan
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$$ Re: merging to different sheets

2008-09-04 Thread Alokeshwar Tiwary
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

$$Excel-Macros$$ Re: merging to different sheets

2008-09-04 Thread Akhilesh Karna
You can use the following macro if your filenames are really as you said. Further you need to change the path to the file. You need to check the name of sheet also. Hope it helps. '- Sub combineWorkbooks Dim i As Integer Dim j As Integer Dim w1 As

$$Excel-Macros$$ Re: merging to different sheets

2008-09-04 Thread Xebec Groups
Dear it would be better to exctly tell what you want to do of these files are these files are Leads ? On Wed, Sep 3, 2008 at 4:37 PM, A.A.A <[EMAIL PROTECTED]> wrote: > > Hi, > I have 300 excel files and another different 300. I want to merge one > from the first 300 to one from the other 30