|
楼主 |
发表于 2017-3-8 16:51
|
显示全部楼层
请问如何根据数据表生成两个表格
http://club.excelhome.net/thread-1332493-1-1.html
(出处: ExcelHome技术论坛)
Sub lsc()
Dim arr
arr = [A1].CurrentRegion
ReDim brr(1 To 20000, 1 To 9)
ReDim crr(1 To 20000, 1 To 4)
For i = 2 To UBound(arr)
If arr(i, 2) <> "" Then
k = k + 1: m = m + 1
brr(k, 1) = arr(i, 2): brr(k, 2) = arr(i, 3): brr(k, 3) = arr(i, 7)
If (Len(arr(i, 4)) <> 18) * (Len(arr(i, 4)) <> "") Then
brr(k, 4) = "港澳台身份证"
Else
brr(k, 4) = "居民身份证"
End If
brr(k, 5) = arr(i, 4): brr(k, 6) = "父亲": brr(k, 7) = arr(i, 49): brr(k, 8) = arr(i, 50): brr(k, 9) = "是"
crr(m, 1) = arr(i, 2): crr(m, 2) = arr(i, 4): crr(m, 3) = arr(i, 7): crr(m, 4) = arr(i, 3)
End If
Next
With Sheets("微课掌上通导入")
.[a3:i20000] = ""
.Columns("E").NumberFormatLocal = "@"
.[a3].Resize(k, 9) = brr
End With
With Sheets("市安全教育平台导入")
.[a4:d20000] = ""
.Columns("B").NumberFormatLocal = "@"
.[a4].Resize(m, 4) = crr
End With
End Sub |
|