本帖最后由 蜀西 于 2022-2-21 16:08 编辑
23423423424
- Sub test()
- Dim arrClm, i&, j&, k&, c&, n&
- arrClm = Array(1, 1, 1, 1, 3, 0, 0, 2, 0, 4)
- Sheets("CC").[a3:m30].ClearContents
- For j = 0 To 9
- c = arrClm(j)
- If c Then
- n = Sheets("BB").Cells(2, j + 1)
- For i = 3 To 30
- For k = 1 To c
- If Sheets("BB").Cells(i, j + k) <> "" And Sheets("BB").Cells(i, j + k) = n Then Exit For
- Next k
- If k < c + 1 Then Sheets("CC").Cells(i, j + 1).Resize(, c) = Sheets("AA").Cells(i, j + 1).Resize(, c).Value
- Next i
- End If
- Next j
- End Sub
复制代码
|