omar68

Thanks :( for this big effort

to open the first workbook Workbooks.Open Filename:= _ "C:\Book1.xls" to select a column then copy it Columns("C:C").Select Selection.Copy then open the other workbook same as before then select the sheet and the columns Sheets("Sheet2").Select Columns("C:C").Select then paste ActiveSheet.Paste Application.CutCopyMode = False then save the destination workbook and close both files ActiveWorkbook.Save ActiveWindow.Close ActiveWindow.Close