|
2学分
要求:
目前已实现按条件(门牌号)复制模板并命名工作表,现需要按门牌号将信息表中的A5~A22的数据提取到门牌号工作表B11~T26工作区域中,要求从B11行开始,根据家庭人员情况逐行逐条提取。
目前程序不能按门牌号提取全部家庭人员信息,只能提取一条信息,是从B18开始,
Sub demo()
Set d = CreateObject("scripting.dictionary")
a = Sheet1.[a1].CurrentRegion
For i = 3 To UBound(a)
d(a(i, 5)) = i
Next
Set o = Sheet1.Range("o1:ag" & UBound(a))
s = 2
For sh = 3 To Sheets.Count
With Sheets(sh)
e = d(.Name)
ot = o.Offset(s, 0).Resize(e - s, 19)
.[b11:u26].ClearContents
.[b11].Resize(e - s, 19) = ot
End With
s = e
Next
End Sub
祝順心,南無阿彌陀佛!
|
最佳答案
查看完整内容
Sub demo()
Set d = CreateObject("scripting.dictionary")
a = Sheet1.[a1].CurrentRegion
For i = 3 To UBound(a)
d(a(i, 5)) = i
Next
Set o = Sheet1.Range("o1:ag" & UBound(a))
s = 2
For sh = 3 To Sheets.Count
With Sheets(sh)
e = d(.Name)
ot = o.Offset(s, 0).Resize(e - s, 19)
..ClearContents
..Resize(e - s, 19) = ot
...
|