|
- Sub Macro1()
- Dim arr, brr, ar, br, d, d2, i&, j%
- Set d = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("b1").CurrentRegion
- brr = Sheet1.[e2:g25]
- For i = 1 To UBound(brr)
- s = IIf(i < 12, 1, 2)
- d(brr(i, 1) & "," & s) = brr(i, 3)
- Next
- ar = Sheet2.Range("b1").CurrentRegion
- br = Sheet2.[k2:m25]
- For i = 1 To UBound(br)
- s = IIf(i < 12, 1, 2)
- d2(br(i, 1) & "," & s) = br(i, 3)
- Next
- n = UBound(arr)
- n2 = UBound(ar)
- x = Split(arr(n, 1))
- Open ThisWorkbook.Path & "\1.txt" For Output As #1
- For j = 1 To 2
- For i = 0 To UBound(x)
- Print #1, d(x(i) & "," & j)
- Next
- Next
- For j = 1 To 2
- For i = 1 To UBound(ar, 2)
- Print #1, d2(ar(n2, i) & "," & j)
- Next
- Next
- Close #1
- End Sub
复制代码 |
|