Excel VBA copy values from one sheet to Another

Dear all,

I have attached an excel file here, it is self explanatory, first sheet is for invoice entry, when I click generate button data should copy to print sheet. data should paste transpose mode, insert rows, should skip blank rows. please look into this and help me if you can.

rgdsinvtst.xlsm

Thanks for the reply.
No, all services should be on the print sheet, down by down.

PCI,
Sorry for my poor explanation.
In sheet "Invoice entry" the service1 is just a description. it may repeat also.
We need to prepare only one "Print" sheet. "Print should be" which I added is for how the output should be.

If you run my code, everything is perfect except skipping the blank cells. It counts the right-side columns of each "particular" but displays blank cells and corresponding headers too. I want to paste only the cell values that are not equal to zero and the corresponding headers.
Thanks

PCI,
Sorry, this is not the code I am really looking for.

See if this is how you wanted.

Please Login or Register  to view this content.

Jindon,

Excellent! 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.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.