|
不知道是不是楼主要的效果
- Sub Macro2()
- Dim arr, brr, crr, d, i&, j&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("离职").UsedRange
- For i = 4 To UBound(arr)
- If arr(i, 17) = "离职" Then d(arr(i, 4)) = arr(i, 17)
- Next
- For i = 1 To Sheets.Count
- If Sheets(i).Name <> "离职" And Sheets(i).Name <> "持证" And Sheets(i).Name <> "持证分布情况" And Sheets(i).Name <> "模糊查询" And Sheets(i).Name <> "公司组织培训情况" And Sheets(i).Name <> "持证汇总表" And Sheets(i).Name <> "持双证查询" And Sheets(i).Name <> "队员持证情况多条件查询" And Sheets(i).Name <> "消安队持证情况多条件查询" And Sheets(i).Name <> "离职(自行)" And Sheets(i).Name <> "职业名称新旧对照表" Then
- k = Sheets(i).Range("E65536").End(xlUp).Row
- brr = Sheets(i).UsedRange
- crr = d.keys
- For j = 0 To d.Count - 1
- For k = 3 To UBound(brr)
- If crr(j) = brr(k, 5) Then
- brr(k, 18) = "糖糖糖糖" '--->这里填“离职” 我写这个是验证用
- End If
- Next
- Next
- Sheets(i).Range("A1").Resize(UBound(brr, 1), UBound(brr, 2)) = brr
- End If
- Next
- End Sub
复制代码 |
|