VBA MACRO CODE FOR REMOVING CELLS AND APPEARING IT CONTINOUSLY

[Dharani]

Dear Sir /Madam,
The sheet 1 (input file) is the given file. i need output like in the Sheet2(required output sheet). For easy understanding i had given colors for your kind reference. from that lease remove the cell apsim version cell and the headings from the second set onwards.

in simple words I need output like in the second sheet. (hope I m not confusing)please do help me...

please oblige and do the needful... PLEASE FIND THE ATTACHMENT...

Thanks & Regards,
Dharani.
full files.xls

[p45cal]

cross posted at least at http://www.excelforum.com/excel-prog...ntinously.html

[patel]

---------------- deleted