|
发表于 2017-4-21 09:23
|
显示全部楼层
本楼为最佳答案
简单改了下- Sub jihua()
- Dim row%, jhrow%, t&
- t = Timer
- For row = 2 To Cells(Rows.Count, "a").End(3).row
- For jhrow = 2 To Sheets("计划工时").Cells(Rows.Count, "a").End(3).row
- If Cells(row, "b") = Sheets("计划工时").Cells(jhrow, "b") And Cells(row, "c") = Sheets("计划工时").Cells(jhrow, "c") And Sheets("计划工时").Cells(jhrow, "e") Like "*" & Cells(row, "e") & "*" Then
- Cells(row, "p") = Sheets("计划工时").Cells(jhrow, "d")
- Cells(row, "q") = Sheets("计划工时").Cells(jhrow, "f")
- End If
- Next
- Next
- MsgBox Timer - t & "秒"
- End Sub
复制代码 运行结果如图,该有的都有了 |
|