Moderate working code to be shorter

[abjac]

Hi I Would like to have some help to make this below code shorter. Its working and I have not been able to do it different.
But its really big code and for sure it can be made shorter.

Please have a look and see if you can help

Sincerely

Abjac

Please Login or Register  to view this content.

[lancer102rus]

Please Login or Register  to view this content.

[jindon]

Try

Please Login or Register  to view this content.

If only cell format then simply

Please Login or Register  to view this content.

[abjac]

Hi and thanks to both of you.

I checked both codes to make it more special I have below test sheet. Its some I had problems with,.And I need to be sure it can do it here.

Yours Lancer I cant make it work on this test sheet. And yours Jindon it works perfect, but I need it not to fill out the empty cells. Can that be changed? It can be sometimes, there is empty cells on some times empty columns and in this case I shall not have the zeroes. Because after I have to make a csv file.
Please have a look at the test sheet I upload here

Thanks

Abjac

[jindon]

Did you try my second code?

If the other...

Please Login or Register  to view this content.

[abjac]

Hi Jindon that did the trick the code work brilliant.

Thanks allot really great

Have a nice day.

Sincerely
Abjac