|
忘了你还要求有序号
现在补上
- Private Sub MergeTbl_Click()
- Dim arr(1 To 4) As String
- Dim tempArr()
- Dim i As Integer
- Dim j As Integer
- Dim k As Integer
- Dim m As Integer
- Dim intRows As Long
- Dim strSheetName As String
- Application.ScreenUpdating = False
- j = 1
- m = 1
- For i = 1 To ActiveWorkbook.Sheets.Count
- strSheetName = ActiveWorkbook.Sheets(i).Name
- Select Case Left(strSheetName, 1)
- Case "二", "四", "八", "8"
- arr(j) = strSheetName
- j = j + 1
- End Select
- Next
- intRows = (Worksheets(arr(1)).Range("A65536").End(xlUp).Row - 2) * UBound(arr)
- Range(Cells(2, 1), Cells(intRows + 1, 9)).ClearContents
- ReDim tempArr(1 To intRows, 1 To 8)
- Range("A2") = m
- For i = 1 To intRows
- k = i Mod UBound(arr)
- If k = 0 Then
- k = UBound(arr)
- End If
- tempArr(i, 1) = arr(k)
- For j = 2 To 8
- tempArr(i, j) = Worksheets(arr(k)).Cells(m + 2, j - 1)
- Next
- If i Mod UBound(arr) = 0 Then
- m = m + 1
- If m <= intRows / UBound(arr) Then
- Range("A" & 2 + i) = m
- End If
- End If
- Next
- Range(Cells(2, 2), Cells(intRows + 1, 9)) = tempArr
- Application.ScreenUpdating = True
- End Sub
复制代码 顺便说一下,为了测试,验证,四个基础表得第一列数量更改成有规律的数据.
|
本帖子中包含更多资源
您需要 登录 才可以下载或查看,没有帐号?注册
x
|