|
发表于 2017-8-25 16:18
|
显示全部楼层
本楼为最佳答案
我的理解是,根据sheet2的A列从sheet1中取值。
另,建议用数组。
- Sub t()
- Dim i, s
- i = Sheet1.Cells(Rows.Count, 1).End(3).Row
- s = Sheet2.Cells(Rows.Count, 1).End(3).Row
- Set d1 = CreateObject("Scripting.Dictionary")
- For w = 2 To i
- d1(Sheet1.Cells(w, 1).Value) = Sheet1.Cells(w, 2)
- Next w
- For a = 2 To s
- Sheet2.Cells(a, 2) = d1(Sheet2.Cells(a, 1).Value)
- Next a
- Set di = Nothing
- End Sub
复制代码 |
|