|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
楼主已经有代码了,简单修改了一下。
- Sub 添加各科缺考学生到目标表()
- With Worksheets("原始表")
- r = .Cells(.Rows.Count, 1).End(xlUp).Row
- c = .Cells(1, .Columns.Count).End(xlToLeft).Column
- arr = .Range("a1").Resize(r, c)
- ReDim brr(1 To UBound(arr) * (UBound(arr, 2) - 6), 1 To 7)
- m = 0
- For j = 7 To UBound(arr, 2)
- If Application.Count(Application.Index(arr, 0, j)) > 0 Then
- For i = 2 To UBound(arr)
- If Len(arr(i, j)) = 0 Or arr(i, j) = 0 Then
- m = m + 1
- brr(m, 1) = 7 '年级
- brr(m, 2) = arr(1, j) '科目
- brr(m, 3) = arr(i, 5) '试场
- brr(m, 4) = arr(i, 6) '座号
- brr(m, 5) = arr(i, 1) '班级
- brr(m, 6) = arr(i, 3) '姓名
- brr(m, 7) = arr(i, j) '分数
- End If
- Next
- End If
- Next
- End With
- With Sheets("目标表")
- .Range("A" & .Range("B65535").End(3).Row + 1).Resize(m, UBound(brr, 2)) = brr
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|