|
楼主 |
发表于 2017-5-24 13:57
|
显示全部楼层
- Private Sub CommandButton21_Click()
- Worksheets("sheet2").Activate
- For a = 2 To 7
- Worksheets("sheet2").Cells(a, 2) = WorksheetFunction.SumIf(Columns("y:y"), Worksheets("sheet2").Cells(a, 1), Columns("m:m"))
- Worksheets("sheet2").Cells(a, 3) = WorksheetFunction.Index(Columns("a:a"), WorksheetFunction.Match(Worksheets("sheet2").Cells(a, 1), Columns("y:y"), 0))
- Worksheets("sheet2").Cells(a, 4) = WorksheetFunction.Index(Columns("u:u"), WorksheetFunction.Match(Worksheets("sheet2").Cells(a, 1), Columns("y:y"), 0))
- Next
- End Sub
复制代码 |
|