|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub t()
- Dim arr(1 To 26, 1 To 16), brr(1 To 23, 1 To 16), i%, x%, y%, d, k
- Set d = CreateObject("Scripting.Dictionary")
- x = 1: y = 1
- For i = 2 To [a65536].End(3).Row
- If Range("b" & i) = "A" Then
- If Range("a" & i) = "多选" Then
- arr(x, 1) = Range("a" & i)
- arr(x, 2) = Range("b" & i)
- arr(x, 3) = Range("c" & i)
- arr(x, 4) = Range("d" & i)
- arr(x, 5) = Range("e" & i)
- arr(x, 6) = Range("f" & i)
- arr(x, 7) = Range("g" & i)
- arr(x, 8) = Range("h" & i)
- arr(x, 9) = Range("i" & i)
- arr(x, 10) = Range("j" & i)
- arr(x, 11) = Range("k" & i)
- arr(x, 12) = Range("l" & i)
- arr(x, 13) = Range("m" & i)
- arr(x, 14) = Range("o" & i)
- arr(x, 15) = Range("p" & i)
- arr(x, 16) = Range("q" & i)
- x = x + 1
- Else
- brr(y, 1) = Range("a" & i)
- brr(y, 2) = Range("b" & i)
- brr(y, 3) = Range("c" & i)
- brr(y, 4) = Range("d" & i)
- brr(y, 5) = Range("e" & i)
- brr(y, 6) = Range("f" & i)
- brr(y, 7) = Range("g" & i)
- brr(y, 8) = Range("h" & i)
- brr(y, 9) = Range("i" & i)
- brr(y, 10) = Range("j" & i)
- brr(y, 11) = Range("k" & i)
- brr(y, 12) = Range("l" & i)
- brr(y, 13) = Range("m" & i)
- brr(y, 14) = Range("o" & i)
-
- y = y + 1
- End If
- End If
- Next
- Stop
- For i = 1 To 26
- d(WorksheetFunction.RandBetween(1, 26)) = ""
- Next
- s = d.keys
- Stop
- Sheet2.Select
- For i = 2 To 13
- Sheet2.Range("a" & i) = arr(s(i - 2), 1)
- Sheet2.Range("b" & i) = arr(s(i - 2), 2)
- Sheet2.Range("c" & i) = arr(s(i - 2), 3)
- Sheet2.Range("d" & i) = arr(s(i - 2), 4)
- Sheet2.Range("e" & i) = arr(s(i - 2), 5)
- Sheet2.Range("f" & i) = arr(s(i - 2), 6)
- Sheet2.Range("g" & i) = arr(s(i - 2), 7)
- Sheet2.Range("h" & i) = arr(s(i - 2), 8)
- Sheet2.Range("i" & i) = arr(s(i - 2), 9)
- Sheet2.Range("j" & i) = arr(s(i - 2), 10)
- Sheet2.Range("k" & i) = arr(s(i - 2), 11)
- Sheet2.Range("l" & i) = arr(s(i - 2), 12)
- Sheet2.Range("m" & i) = arr(s(i - 2), 13)
- Sheet2.Range("n" & i) = arr(s(i - 2), 14)
- Sheet2.Range("o" & i) = arr(s(i - 2), 15)
- Sheet2.Range("p" & i) = arr(s(i - 2), 16)
- Next
- Stop
- d.RemoveAll
- For i = 1 To 23
- d(WorksheetFunction.RandBetween(1, 23)) = ""
- Next
- s = d.keys
- For i = 14 To 21
- Sheet2.Range("a" & i) = brr(s(i - 14), 1)
- Sheet2.Range("b" & i) = brr(s(i - 14), 2)
- Sheet2.Range("c" & i) = brr(s(i - 14), 3)
- Sheet2.Range("d" & i) = brr(s(i - 14), 4)
- Sheet2.Range("e" & i) = brr(s(i - 14), 5)
- Sheet2.Range("f" & i) = brr(s(i - 14), 6)
- Sheet2.Range("g" & i) = brr(s(i - 14), 7)
- Sheet2.Range("h" & i) = brr(s(i - 14), 8)
- Sheet2.Range("i" & i) = brr(s(i - 14), 9)
- Sheet2.Range("j" & i) = brr(s(i - 14), 10)
- Sheet2.Range("k" & i) = brr(s(i - 14), 11)
- Sheet2.Range("l" & i) = brr(s(i - 14), 12)
- Sheet2.Range("m" & i) = brr(s(i - 14), 13)
- Sheet2.Range("n" & i) = brr(s(i - 14), 14)
- Sheet2.Range("o" & i) = brr(s(i - 14), 15)
- Sheet2.Range("p" & i) = brr(s(i - 14), 16)
- Next
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|