Copy two sheets data in new work book with two sheets. [Closed]

Report
-
Hello,

I have a work book like....
Sheet 1: It has student detials (Enrollment No, Name, father name, Dob, Date of Joining). count of "N" Students.
Sheet 2: has Enrollment No, Hall ticket, Subjects to appear.
Sheet 3: has Subject1 (Gained Marks, Min Marks,total Marks, % he scored) mapped with Hall Ticket.
Sheet 4: has Subject2 (Gained Marks, Min Marks,total Marks, % he scored) mapped with Hall Ticket.
Sheet 5: has Subject3 (Gained Marks, Min Marks,total Marks, % he scored) mapped with Hall Ticket.

Now I need a macro with Create a new work Book with Two Sheets: map the Student details...
Sheet1: Student details ( Hall Ticket No, Name of Student, Subjects)
Sheet2: Subjects of particular Student appeared with Marks and percentage.

Like wise i need "N" work books for "N" students.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!