- Private Sub CommandButton1_Click()
- UserForm1.Hide
- Dim arr, i&, BtAr, Ar(1 To 8, 1 To 7)
- BtAr = Array("名次", "号码", "姓名", "班级", "成绩", "分值", "备注")
- arr = Worksheets("3").Range("A1").CurrentRegion.Value
- For i = 2 To UBound(arr)
- If arr(i, 1) = ComboBox2.Value And Len(arr(i, 10)) Then
- Ar(arr(i, 8), 1) = arr(i, 8)
- Ar(arr(i, 8), 2) = arr(i, 4)
- Ar(arr(i, 8), 3) = arr(i, 5)
- Ar(arr(i, 8), 4) = arr(i, 6)
- Ar(arr(i, 8), 5) = arr(i, 7)
- Ar(arr(i, 8), 6) = arr(i, 10)
- Ar(arr(i, 8), 7) = arr(i, 9) & arr(i, 11)
- End If
- Next i
- Range("a1").Resize(1, 7) = BtAr
- Range("a2").Resize(8, 7) = Ar
- End Sub
复制代码
提取数据.rar
(18.63 KB, 下载次数: 18)
|