i need is to copy A1 to C1 in the first workbook. Then save and closeit.. open the second book and copy A2:C2 in that book..save and closeit.. open the next copy a3:C3 into that etc...