Tet Htut Naing
Board Regular
- Joined
- Mar 28, 2015
- Messages
- 101
Dear All,
I am trying to write a macro and cannot start. I want to copy the same position rows of all sheets in a workbook and paste them in the last rows of sheets in another workbook. Here, sheets' names of those two workbooks are the same. I am trying to save the records of resigned staff (NGO).
In details, in the first sheet of the first workbook, I will select a row and run the macro, then it will copy all the same position rows of all sheets of that workbook, and paste all the copied rows at the last rows of all sheets in the second workbook.
If it is possible, please help me on this.
Best Regards,
Ko Htut
I am trying to write a macro and cannot start. I want to copy the same position rows of all sheets in a workbook and paste them in the last rows of sheets in another workbook. Here, sheets' names of those two workbooks are the same. I am trying to save the records of resigned staff (NGO).
In details, in the first sheet of the first workbook, I will select a row and run the macro, then it will copy all the same position rows of all sheets of that workbook, and paste all the copied rows at the last rows of all sheets in the second workbook.
If it is possible, please help me on this.
Best Regards,
Ko Htut