copy file to other
 

Hello,

how can I copy file1 to another file2?
But how can I do this:
If I have in file1 a column "A" values in the cells and in file2 somewhere
a value "X" so I like to let this value and go over to other
cell in the same column and copy the cells from file1 until another "X"
appears and so go on till the end?

My solution for copy from file1 to fiel2:
Workbooks("file1.xls").Worksheets("sheet1").Range( "A1:A300").Copy _
Workbooks("file2.xls").Worksheets("sheet2").Range( "A1")

Thanks in advance!