any clue?

  • Thread starter Thread starter vikram
  • Start date Start date
V

vikram

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
 
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.
 
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)
 
Back
Top