|
发表于 2012-1-13 11:41
|
显示全部楼层
本楼为最佳答案
本帖最后由 sunjing-zxl 于 2012-1-13 14:42 编辑
- Sub aa()
- Dim arr, str1 As String, str2 As String
- Dim i As Long, j As Long, n As Long
- str1 = Cells(2, 1)
- str2 = Cells(2, 2)
- Range(Cells(5, 1), Cells([A65536].End(xlUp).Row, 15)).ClearContents
- With Sheets("成绩登记表")
- arr = .Range(.Cells(4, 1), .Cells(.[A65536].End(xlUp).Row, 16))
- End With
- ReDim arr1(1 To UBound(arr), 1 To 14)
- For i = 1 To UBound(arr)
- If arr(i, 2) = str1 And arr(i, 3) = str2 Then
- n = n + 1
- arr1(n, 1) = arr(i, 1)
- For j = 4 To 16
- arr1(n, j - 2) = arr(i, j)
- Next j
- End If
- Next i
- Range("A5").Resize(UBound(arr1), 14) = arr1
- If n = 0 Then
- Range("A5") = "无"
- End If
- End Sub
复制代码 附件:
教育质量检测成绩登记表及质量分析表-sunjing.rar
(275.8 KB, 下载次数: 117)
|
|