Macro to include addtional rows/columns

Hi all ,

I 've a following macro which i got with big help from lot of frnds from excel forum. This runs just perfect . Now i need to make addtion to this macro.

Currently this macro works if rows in my data sheet remain same . To make it easy to understand have a look in attached excel sheet . If i have those highlightes columns , macros does not work , if i remove them it works. can some kindly update this macro to include thos highlighted columns.

Also please inform which part/parts of macro has been update as it will increase my knowledge.

Here is the code & attached file.

Test File

Please Login or Register  to view this content.

Please ask me if any questions abt my request.

Any Help guys ?? plz..???

bump..bump...any assistance plz?

Help ...