Sub test()
Dim arr, brr()
Dim i&, j&, k%, m&
'arr = Range("a1").CurrentRegion '
arr = Sheets(2).Range("a1:j11").Value '数据源区域按实际自行修改
ReDim brr(1 To UBound(arr), 1 To UBound(arr, 2))
For i = 1 To UBound(arr)
k = 0
For j = 1 To UBound(arr, 2)
If arr(i, j) <> "" Then k = k + 1
If k >= 6 Then Exit For
Next
If k < 6 Then
m = m + 1
For j = 1 To UBound(arr, 2)
brr(m, j) = arr(i, j)
Next
End If
Next
With Sheets(3)
.UsedRange.Clear
If m > 0 Then .Range("a1").Resize(m, UBound(arr, 2)) = brr
End With
End Sub