Insert Row if the Entire Row Cell has Zero

[unknownymous]

Hi Guys,

How can I insert a blank row if the entire row has zero ?

Before:

Name	Track1	Track2	Track3	Track4
Ben	1	1	1	2
Sam	3	4	5	6
Anna	1	0	5	9
Ted	0	0	0	0

<tbody>
</tbody>

After:

Name	Track1	Track2	Track3	Track4
Sam	3	4	5	6
Ben	1	1	1	2
Anna	1	0	5	9
ZEROES
Ted	0	0	0	0

<tbody>
</tbody>

Thanks in advance for the help.

 

[Peter_SSs]

1. What columns are we looking at?

1. As for my example above, Ems should be separated so additional row will set as separator - that is if the Score1 & 2 is ZERO

That doesn’t seem to answer my Q1

 

[unknownymous]

We're looking at columns 5 & 6.

 

[Peter_SSs]

We're looking at columns 5 & 6.

My question was about post #25 so I assume this answer actually means we are looking at columns A:F. However, I am away from home at the moment so not quite sure when I will be able to answer this. Will do so when I can.

 

[unknownymous]

Thanks Peter! I was able to find the codes already so we're done with this.