copy file to other

P

p. panter

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top