Copy Transpose Paste

Hi,

In the enclosed file i need some help in copy paste the data from Payslip to Template in two sets - Gross & Deductions

In each sets 0 should values to be ignored & keep the order of components as same. After this I want to paste the the Gross Total with amount & Deductions Total with amount as shown in template after the avaialble last row. This Totals should not be constant as if the pay elements increases totals may have to shift the rows.
After this leaving a balnk row i want to paste Net Pay.

Could any one please help me on this.

See if this is how you wanted.

Please Login or Register  to view this content.

Thanks a lot jindon. It works totally fine. Just what i needed.
Thank you.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.