Copy multiple cell value after four rows

**aalokwar** · 07-18-2011, 06:47 AM

Hi,
I want to copy attached data into different format. For one student his paper1/2/3/4 marks should be arranged in below shown format.

Paper code should be copied manually. Formula should be used to copy Name and Marks for all paper.
----------------
Please check the link given below for details and reply if its possible to do.
Thanks in Advance...

Please check the attached excel file for complete details.

**Azam Ali** · 07-18-2011, 07:03 AM

Hi aalokwar

in attatched file, copy cells A16 to G19 and paste from A20 to A47

**aalokwar** · 07-18-2011, 07:33 AM

Originally Posted by Azam Ali

Hi aalokwar

in attatched file, copy cells A16 to G19 and paste from A20 to A47

Dear Azam,
You are great. You have solved a huge problem in very simple way.
Thanks a lot...

**Azam Ali** · 07-18-2011, 09:02 AM

If your problem is solved, mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.