Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data for match word from one file to another file | Excel Worksheet Functions | |||
How do I copy a excel file into a InDesign file correctly? | Excel Discussion (Misc queries) | |||
copy the same raws of all sheets from about a 100 file to a new sheet of a book and save the file | Setting up and Configuration of Excel | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel | |||
VBA Macro to copy an column from one Excel file into another file | Excel Programming |