count each number half set 3n

Martin
1- don't have to be red
2-let me add the formula

You can change the font color also:)

Martin

do you need to finish it ?
when i make the changes ?

No.

Great Job ! Expert

why  guides numbers dissaper ??

after hit the MIDWAY button?? Please

I'm sorry about that. You have a column (FG) that has zero width that fooled me. In any case in the 'Midway' macro change

Range("FH4:FK" & ActiveSheet.UsedRange.Rows.Count).ClearContents

- to -

Range("FI4:FK" & ActiveSheet.UsedRange.Rows.Count).ClearContents

I've attached a corrected workbook.
29082356a.xlsm

Great !! Job  

working as needed !!

Best Expert !

BTW you have several columns like that and it would be a big job but they should be removed and all the code adjusted to the fact that they're gone.

Martin

you rigth   that will make the  workbook more faster an  robust

im again the time

I don't think it will make it any faster, but it would help avoid mistakes like this one.

im agree with you Best Expert