Formatting the data with the help of VBA Macro

[gyan123]

Hello excel friends........this is my first post here, i am in a problem
i am uploading a Excel file, it contains 3sheets ("Sheet1", "DD" and "Final_Result") I want rearrange the data of Sheet1 like Final_Result Sheet (for better understand what i want to do please see the attached image or download Excel file and see Final_Result sheet (Final_Result sheet is only for demonstration for what i want in sheet1's data).

Note:- (1,2,3 is only for attention in Final_Result sheet)

1. insert 10 rows after H15
2. Now after add 10 rows and Sort the data according to the D_Code (Col-E), please see the Result_Sheet for better understand (61 or 90)
3. Here again insert 10 more rows (see the Result_Sheet's 2No.)
4. After sort we have data of 4 employees which have D_Code 61, now here copy the data from DD Sheet and paste it in 5 Sr. No. (Please see the Result_Sheet's Yellow part) and make a total of Col-F
4. Now we have the data of those employee whose D_Code have only 90 here make a total of Col-F in last. Here it is complete.Final Result.jpg