I have an excel file with some data till row 50.(can be more or less)
and another excel file with data till row 100 (can be more or less)

what i want is that i get a macro which automatically adds the dat
from second sheet below the data in sheet 1.

the data in first file can end on row 50 or 60 or at any row

thank u so much

any ideas


and i have to combine more 30 files like these into that first file

--
Message posted from http://www.ExcelForum.com

asked in misc. Please do not multipost as most read all and please try to
use more creative subject lines than "any clue" or "any idea". The archives
will appreciate it.

--
Don Guillett
SalesAid Software

"vikram " wrote in message
...
I have an excel file with some data till row 50.(can be more or less)
and another excel file with data till row 100 (can be more or less)

what i want is that i get a macro which automatically adds the data
from second sheet below the data in sheet 1.

the data in first file can end on row 50 or 60 or at any row

thank u so much

any ideas


and i have to combine more 30 files like these into that first file.


---
Message posted from http://www.ExcelForum.com/

Here's some code

Dim rng As Range

With Worksheets("Sheet1")
Set rng = .Range("A1").Offset(.Cells(Rows.Count, "A").End(xlUp).Row)
End With

With Worksheets("Sheet2")
.Rows("1:" & .Cells(Rows.Count, "A").End(xlUp).Row).Copy _
Destination:=rng
End With

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"vikram " wrote in message
...
I have an excel file with some data till row 50.(can be more or less)
and another excel file with data till row 100 (can be more or less)

what i want is that i get a macro which automatically adds the data
from second sheet below the data in sheet 1.

the data in first file can end on row 50 or 60 or at any row

thank u so much

any ideas


and i have to combine more 30 files like these into that first file.


---
Message posted from http://www.ExcelForum.com/