|
凑热闹,没写判断、删除表的代码
Sub test()
Dim d
Set d = CreateObject("scripting.dictionary")
ar = Sheets("表1").[C4:ba12].Value
For i1% = 2 To UBound(ar, 2)
If ar(1, i1) = 1 Then xq = xq% + 1
For i2% = 2 To UBound(ar)
d(ar(1, i1) & "|" & ar(i2, i1)) = d(ar(1, i1) & "|" & ar(i2, i1)) & "、" & xq & "-" & ar(i2, 1)
ss1 = ar(1, i1) & "|" & ar(i2, i1)
ss2 = d(ss1)
Next i2, i1
ss2 = d("1|语")
ar = Sheets("表2").[a2:l4].Value
For i1 = 1 To UBound(ar)
Set s = Sheets.Add
s.Name = ar(i1, 1)
Sheets("表3").Cells.Copy s.[a1]
s.[g2] = ar(i1, 1)
For i2 = 3 To UBound(ar, 2)
If ar(i1, i2) <> "" Then
For Each stmp In Split(Mid(d(ar(i1, i2) & "|" & ar(i1, 2)), 2), "、")
s.Cells(Right(stmp, 1) * 1 + 4, Left(stmp, 1) * 1 + 2) = "七(" & ar(i1, i2) & ")"
Next
End If
Next
Next
End Sub
|
评分
-
查看全部评分
|