Copy, Transpose & Paste

Thanks to Jindon who gave me the solutions on this
https://www.excelforum.com/excel-pro...ml#post4798984

It's working fine. But i just a need small change in this. If the number of components under Deductions are more it's not considering to paste the total values at the end of last cell under deductions. If the number of components under deductions are more then pasting of totals under deductions & gross based on at the last cell data under deductions is getting wrong.

Could please any one help on this.

Hi Sktneer,

Thank you for the reply. I the template sheet i wanted both totals of Gross & Deductions in the same Row. In the code you provided i still need some changes to be made to shift the totals of Gross to match to the last row of Deductions. Like the same way if Gross components are more total of deductions should shift to the same of gross total.

Could you please make this change.

Do you mean like this?

Please Login or Register  to view this content.

Cleaned up a bit.

Please Login or Register  to view this content.

P.S
Vcare
You should mark the previous thread as "SOLVED".

Thank you Jindon... It worked awesome...