|
根据“加结婚证号”上女方身份证号码在“民政婚姻登记”表里查找改对象的结婚证号,并将这个号复制到“加结婚证号”表的结婚证号里!谢谢!
- Sub Macro1()
- Dim arr, brr, d, i&
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("a1").CurrentRegion
- brr = Sheet2.Range("a1").CurrentRegion
- For i = 2 To UBound(brr)
- d("" & brr(i, 12)) = brr(i, 4)
- Next
- For i = 2 To UBound(arr)
- arr(i, 1) = d("" & arr(i, 16))
- Next
- Sheet1.Range("a1").Resize(UBound(arr)) = Application.Index(arr, 0, 1)
- End Sub
复制代码
|
|