Hi all,
I want to create a result sheet of each student on sheet2. I want to keep 4 rows blank in between two result sheets. I don’t want a formula in any result sheet. The main result sheet is on sheet1 from which I want to extract a result of each student on sheet2.
After creating a result sheet of a student I want to copy it and paste under the result sheet of student keeping 4 rows blank in between two result sheets until the last student’s result on sheet1. The blank draft of result sheet is ‘b2:p14’. The number of student may vary from class to class.
Please suggest me a code for it.
Thanking you in anticipation.
Sincerely,
Mukesh
Bookmarks