Repeat macro in next rows

Hello there,

Please help!

What need to be done is the following;
I need the information out of column C-FJB without "0" in the next tab and with the decription in column A.
The article code need to be added to the information in the next tab.
I have done this with a macro, but my knowlegde is to limited to repeat that over all other columns.

I have added the format what i would like to have on "blad3". Help on this would be very welcome

Thanks in advance,
Br Niels

Fantastic, I am very grateful! Thanks!