Hi all, I want a solution to my new problem.
I have 5 columns, named Subject 1, Subject 2, ...., Subject 5. I want to copy the data under those columns to column G and H.
Conditions:
1) All the data of Subject 1 will copy to column G and all the data of Subject 3 will copy to column H.
2) Where data of Subject 1 will end, Subject 2 will start in column G and for column H, after Subject 3, Subject 4 will start.
3) After coping Subject 2 to column G and Subject 4 to column H, which will end first, Subject 5 will copy in that column.
Challenges:
1) I have 50 rows per room ( from row 3 to row 52, row 53 to row 102 like this) and 35 rooms.
2) Conditions should fulfill per room basis.
For better understand go through the attached file.
I have 5 columns, named Subject 1, Subject 2, ...., Subject 5. I want to copy the data under those columns to column G and H.
Conditions:
1) All the data of Subject 1 will copy to column G and all the data of Subject 3 will copy to column H.
2) Where data of Subject 1 will end, Subject 2 will start in column G and for column H, after Subject 3, Subject 4 will start.
3) After coping Subject 2 to column G and Subject 4 to column H, which will end first, Subject 5 will copy in that column.
Challenges:
1) I have 50 rows per room ( from row 3 to row 52, row 53 to row 102 like this) and 35 rooms.
2) Conditions should fulfill per room basis.
For better understand go through the attached file.