|
参与一下。。。
- Sub ykcbf() '//2024.4.24
- Dim brr(1 To 10000, 1 To 14)
- Set sh = ThisWorkbook.Sheets("总表")
- For Each sht In Sheets
- If sht.Name <> sh.Name Then
- With sht
- kh = .[b4]: dh = .[k4]
- r = .Cells(Rows.Count, 1).End(3).Row
- arr = .Range("a5:l" & r)
- End With
- For i = 2 To UBound(arr)
- If Val(arr(i, 1)) Then
- m = m + 1
- brr(m, 1) = kh
- brr(m, 2) = dh
- For j = 1 To UBound(arr, 2)
- brr(m, j + 2) = arr(i, j)
- Next
- End If
- Next
- End If
- Next
- With Sheets("总表")
- .UsedRange.Offset(2).Clear
- .[a2].Resize(1, 14).Interior.Color = 49407
- .Columns(4).NumberFormatLocal = "m月d日"
- With .[a3].Resize(m, 14)
- .Value = brr
- .Borders.LineStyle = 1
- .HorizontalAlignment = xlCenter
- .VerticalAlignment = xlCenter
- End With
- End With
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|