Remove blank cells for picking slip

Hi all,

I need to create a picking slip that only lists the 'products' and the corresponding value and remove "products" where the value is 0(Zero).

I need help creating VBA/Macro that removes these empty rows and its corresponding cell. Please see the attached Products1 Excel Screenshot and then Products2 Word Screenshot for more information.

This is my first post and I class myself as a beginner in VBA/Macro and I would love to hear back from this forum so I can expand my knowledge.

Thanks

Minya

Thank you PjWhitfield for your prompt response. I will give it a go and see how I end up. Learning to code, as a beginner, is really frustrating but rewarding when it all works out. - It's a different way of thinking. Thanks again.

Hi PJWhitfield,

I have tried to use that code but get an brake error. Can I please have some additional help?