Sub Start()
For i = 2 To 601
For j = 7 To 16
If Cells(i, "C") Like Cells(1, j) Then
'Cells(i, "b").Copy Cells(i, j)
Cells(i, j) = "中"
Else
If i >= 3 Then Cells(i, j) = IIf(Cells(i - 1, j) = "中", 0, Cells(i - 1, j)) + 1
End If
Next
Next
End Sub
Sub Start()
For i = 2 To 601
For j = 7 To 16
If Cells(i, "C") Like Cells(1, j) Then
'Cells(i, "b").Copy Cells(i, j)
Cells(i, j) = "中"
Else
If i >= 3 Then Cells(i, j) = IIf(Cells(i - 1, j) = "中", 0, Cells(i - 1, j)) + 1
End If
Next
Next
End Sub