need a macro which can combine 2 excel sheets data

[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

 

[Frank Kabel]

Hi
as a starting point see
http://www.rondebruin.nl/copy2.htm