Removing specific rows when generating my workbooks

Hello guys,
I hope you are all fine today.
I have already completed my vba scripting through which I would generate workbooks based on a standard template.
The format of all sheets with their respective cell references are totally in harmony with my vba code.
I need only to amend my code for the purpose of deleting specific rows..Whenever i have in my source file specifically in column Q a zero lineitem quantity, i would like to remove the whole row of that item.

Please refer to my source file, then have a look on a sample file through which i show you how my final workbook shall be generated.
Here, you can view into my vba code, that is run inside my template file.

What amendments shall be made to remove only the those rows with Lineitem quantity zero?

Please Login or Register  to view this content.

Please find attached the following files:
source data file.
One sample file named #29390 as the number of its order; i show you through it how i desire to recieve my final generated workbook file.

Thanks a lot for helping me through this.

Please Login or Register  to view this content.

Hey dear, i managed to solve it by adding this....thanks a lot man