|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
本帖最后由 yexin.wu 于 2018-5-10 09:27 编辑
Sub 客户对账单()
Dim d As Object, Itm
Dim Arr, Ary, b%
Set d = CreateObject("Scripting.Dictionary")
Sheets("表").Select
b = [b65536].End(3).Row
Arr = Range("b4", "c" & b)
For b = 1 To UBound(Arr)
d(Arr(b, 1)) = Arr(b, 2)
Next
For Each Itm In d
Sheet2.Copy after:=Sheets(Sheets.Count - 1)
With ActiveSheet
.Name = Mid(Itm, 1, 6)
.[b13] = Itm
.[d8] = d(Itm)
.[d8].NumberFormatLocal = "0.00"
End With
Next
End Sub
|
评分
-
1
查看全部评分
-
|