|
本帖最后由 zxsea_7426 于 2023-3-18 15:10 编辑
- Sub 静态码店员号添加() '根据不是A列不是"静态码店员号:"或者不是"交易日期"添加
- With Sheets("【商户对账单】")
- r_ = .Cells(Rows.Count, 1).End(3).Row
- l_ = .Cells(12, Columns.Count).End(1).Column
- ar = .Range(.[a1], .Cells(r_, l_))
- For i = 11 To UBound(ar)
- If InStr(ar(i, 1), "静态码店") = 1 Then
- 静态码 = ar(i, 2)
- End If
- If ar(i, 1) = "交易日期" Or InStr(ar(i, 1), "静态码店") Then GoTo 100:
- ar(i, 11) = 静态码
- 100:
- Next i
- .[k1].Resize(UBound(ar), 1).NumberFormatLocal = "@"
- .[k1].Resize(UBound(ar), 1) = Application.WorksheetFunction.Index(ar, 0, 11)
- End With
- End Sub
- Sub 静态码店员号添加2() '根据金额添加
- With Sheets("【商户对账单】")
- r_ = .Cells(Rows.Count, 1).End(3).Row
- l_ = .Cells(12, Columns.Count).End(1).Column
- ar = .Range(.[a1], .Cells(r_, l_))
- For i = 11 To UBound(ar)
- If InStr(ar(i, 1), "静态码店") = 1 Then 静态码 = ar(i, 2)
- If IsNumeric(ar(i, 5)) And ar(i, 5) <> "" Then ar(i, 11) = 静态码
- Next i
- .[k1].Resize(UBound(ar), 1).NumberFormatLocal = "@"
- .[k1].Resize(UBound(ar), 1) = Application.WorksheetFunction.Index(ar, 0, 11)
- End With
- End Sub
复制代码
|
|