|
你好,我用代码实现了除了汇总之外的所有要求,汇总是用公式做的,因为代码我还没想好怎么写,先发给你这个,怕你急用,明天再帮你完善- Sub 条件填充()
- Set a = Worksheets("1-人员基本信息")
- Set b = Worksheets("5-编制表(市场部)")
- For j = 3 To 31
- k = 6
- For i = 2 To 408
- If a.Cells(i, 3) = "在职" And a.Cells(i, 11) = "负责人" And b.Cells(j, 2) = a.Cells(i, 10) Then
- b.Cells(j, 5) = a.Cells(i, 4)
- End If
- If a.Cells(i, 3) = "在职" And a.Cells(i, 11) <> "负责人" And b.Cells(j, 2) = a.Cells(i, 10) Then
- b.Cells(j, k) = a.Cells(i, 4)
- k = k + 1
- End If
- Next
- c = WorksheetFunction.CountA(b.Range(b.Cells(j, 5), b.Cells(j, 15)))
- b.Cells(j, 4) = c
- Next
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|