I've a file name xyz saved in a folder EMP.
I've 700 more files with different names of employees in EMP folder
xyz file is open and i will open first employee file and
1- copy data of cell A10, A20 of Sheet1 (employee's file) on A1 and A2 of Sheet1 of xyz file,
2- copy data of A12, A15 of Sheet2 (employee's file) on A6 & A7 of Sheet2 of xyz file and
3- finally "Save As" this xyz file with the name of the employee's file name.
I've around 700 employees file in total. Please let me know any VBA procedure that can help me out.
I've 700 more files with different names of employees in EMP folder
xyz file is open and i will open first employee file and
1- copy data of cell A10, A20 of Sheet1 (employee's file) on A1 and A2 of Sheet1 of xyz file,
2- copy data of A12, A15 of Sheet2 (employee's file) on A6 & A7 of Sheet2 of xyz file and
3- finally "Save As" this xyz file with the name of the employee's file name.
I've around 700 employees file in total. Please let me know any VBA procedure that can help me out.
