|
发表于 2016-12-7 08:52
|
显示全部楼层
本楼为最佳答案
姓名一般不具有唯一性。建议用身份证号什么的做为主键。
- Sub tt()
- Set d = CreateObject("scripting.dictionary")
- Set d1 = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- Set d3 = CreateObject("scripting.dictionary")
-
- arr = Sheet2.[a1].CurrentRegion
- For i = 2 To UBound(arr)
- d1(arr(i, 3)) = arr(i, 4) '年龄
- d2(arr(i, 3)) = arr(i, 5) '性别
- d(arr(i, 3)) = Sheet2.Cells(i, 1).MergeArea.Cells.Count '家庭人数
- Next
-
- arr = Sheet3.[a1].CurrentRegion
- For i = 1 To UBound(arr)
- d3(arr(i, 3)) = arr(i, 11) '电话
- Next
-
- Sheet1.[b2:e1000].ClearContents
- arr = Sheet1.[a1].CurrentRegion
- For i = 2 To UBound(arr)
- x = arr(i, 1)
- arr(i, 2) = d2(x)
- arr(i, 3) = d1(x)
- arr(i, 4) = d3(x)
- arr(i, 5) = d(x)
- Next
- Sheet1.[a1].CurrentRegion = arr
- End Sub
复制代码 |
评分
-
查看全部评分
|