Automatic circle lettering

T

tonyjyoo

Board Regular
Joined
Aug 5, 2016
Messages
167
Hello,

Below is a code I got assistance with that automatically letters groups of cells that net out to 0 and makes them red font color:

Code: 
  Dim R As Long, X As Long, StartRow As Long, LastRow As Long, Total As Double
  Dim Status As String, EText As Variant, FNumbers As Variant
  On Error GoTo SomethingBadMustHaveHappened
  StartRow = 15
  LastRow = Cells(Rows.Count, "F").End(xlUp).Row
  EText = Range(Cells(StartRow, "F"), Cells(LastRow, "F"))
  FNumbers = Range(Cells(StartRow, "G"), Cells(LastRow, "G")).Value
  X = -1
  Status = -1
  Application.ScreenUpdating = False
  For R = 1 To UBound(FNumbers) - 1
    If FNumbers(R, 1) >= 0 And Status < 0 Then
      X = X + 1
      Total = 0
      With Cells(R + StartRow - 1, "F")
        If X < 26 Then
          .Value = .Value & ChrW(X)
        Else
          .Value = .Value & ChrW(Int((X - 26) / 26)) & ChrW(X Mod 26)
        End If
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Name = "Garamond"
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Size = 20
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Color = vbRed
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Bold = True
      End With
    End If
    Status = Sgn(FNumbers(R, 1))
    Total = Total + Round(FNumbers(R, 1), 2)
  Next
SomethingBadMustHaveHappened:
  Application.ScreenUpdating = True
  
  
  
End Sub

Can anyone quickly spot a line in this code that keeps the lettering function but no longer places circles around the letters?

Thanks.
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
This part deals with formatting...

Code: 
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Name = "Garamond"
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Size = 20
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Color = vbRed
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Bold = True
 
Last edited:
Upvote 0
wigi said:
This part deals with formatting...

Code: 
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Name = "Garamond"
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Size = 20
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Color = vbRed
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Bold = True
Click to expand...

Sorry, this is the correct code I have:

Code: 
Dim R As Long, X As Long, StartRow As Long, LastRow As Long, Total As Double
  Dim Status As String, EText As Variant, FNumbers As Variant
  On Error GoTo SomethingBadMustHaveHappened
  StartRow = 15
  LastRow = Cells(Rows.Count, "F").End(xlUp).Row
  EText = Range(Cells(StartRow, "F"), Cells(LastRow, "F"))
  FNumbers = Range(Cells(StartRow, "G"), Cells(LastRow, "G")).Value
  X = -1
  Status = -1
  Application.ScreenUpdating = False
  For R = 1 To UBound(FNumbers) - 1
    If FNumbers(R, 1) >= 0 And Status < 0 Then
      X = X + 1
      Total = 0
      With Cells(R + StartRow - 1, "F")
        If X < 26 Then
          .Value = .Value & ChrW(9398 + X)
        Else
          .Value = .Value & ChrW(9398 + Int((X - 26) / 26)) & ChrW(9398 + (X Mod 26))
        End If
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Name = "Garamond"
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Size = 20
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Color = vbRed
        .Characters(Len(EText(R, 1)) + 1, 1 + Int(X / 26)).Font.Bold = True
      End With
    End If
    Status = Sgn(FNumbers(R, 1))
    Total = Total + Round(FNumbers(R, 1), 2)
  Next
SomethingBadMustHaveHappened:
  Application.ScreenUpdating = True

I think it has something to do with the "Chrw" and "9398"?
 
Upvote 0
Please add some sample data such that we can test/run the code.
 
Upvote 0
A copy/paste of data (with structure) here will suffice.
 
Upvote 0
wigi said:
A copy/paste of data (with structure) here will suffice.
Click to expand...

Here's an example, starting at row 15:

[TABLE="width: 1084"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1214000000[/TD]
[TD]Wells Ops Trf to Union MM[/TD]
[TD]1,500,000.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]121400 Union Bank Money Market Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Wells Ops Trf to Union MM[/TD]
[TD]-1,500,000.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1369000000[/TD]
[TD]Union MM WR Trf Fee[/TD]
[TD]15.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]136900 Miscellaneous Receivables[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1214000000[/TD]
[TD]Union MM WR Trf Fee[/TD]
[TD]-15.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]121400 Union Bank Money Market Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]SEI ACH[/TD]
[TD]696,446.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]SEI ACH[/TD]
[TD]-696,446.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]North American ACH[/TD]
[TD]39,362.94[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]North American ACH[/TD]
[TD]-39,362.94[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Griffin Capital ACH[/TD]
[TD]20,430.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Griffin Capital ACH[/TD]
[TD]-20,430.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]14,633.12[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-14,633.12[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Icon Advisors ACH[/TD]
[TD]9,187.33[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Icon Advisors ACH[/TD]
[TD]-9,187.33[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]American General ACH[/TD]
[TD]8,387.77[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]American General ACH[/TD]
[TD]-8,387.77[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Assetmark ACH[/TD]
[TD]7,141.06[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Assetmark ACH[/TD]
[TD]-7,141.06[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]5,243.65[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-5,243.65[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Anico ACH[/TD]
[TD]4,500.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Anico ACH[/TD]
[TD]-4,500.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Ailic ACH[/TD]
[TD]3,454.52[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Ailic ACH[/TD]
[TD]-3,454.52[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]2,559.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-2,559.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]National Life ACH[/TD]
[TD]2,280.59[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]National Life ACH[/TD]
[TD]-2,280.59[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]2,225.19[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-2,225.19[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]CNL Financial ACH[/TD]
[TD]2,205.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]CNL Financial ACH[/TD]
[TD]-2,205.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Lincoln Benefit ACH[/TD]
[TD]2,134.64[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Lincoln Benefit ACH[/TD]
[TD]-2,134.64[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]1,978.70[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-1,978.70[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]1,740.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-1,740.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]1,177.92[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-1,177.92[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]890.69[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-890.69[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]859.42[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-859.42[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]717.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-717.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Mutual of Omaha ACH[/TD]
[TD]585.14[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Mutual of Omaha ACH[/TD]
[TD]-585.14[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Ash Brokerage ACH[/TD]
[TD]428.76[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Ash Brokerage ACH[/TD]
[TD]-428.76[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]360.15[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-360.15[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]335.86[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-335.86[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Aviva-Alac ACH[/TD]
[TD]297.92[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Aviva-Alac ACH[/TD]
[TD]-297.92[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]American General ACH[/TD]
[TD]272.78[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]American General ACH[/TD]
[TD]-272.78[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]MetLife ACH[/TD]
[TD]255.28[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]MetLife ACH[/TD]
[TD]-255.28[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]220.69[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-220.69[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Plan Member ACH[/TD]
[TD]215.26[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Plan Member ACH[/TD]
[TD]-215.26[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]212.70[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-212.70[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]205.20[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-205.20[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]183.60[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]-183.60[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]181.49[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-181.49[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]National Life ACH[/TD]
[TD]138.41[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]National Life ACH[/TD]
[TD]-138.41[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]131.68[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-131.68[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]97.33[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-97.33[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]95.57[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-95.57[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]North American ACH[/TD]
[TD]88.98[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]North American ACH[/TD]
[TD]-88.98[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]72.54[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]-72.54[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Protective Life ACH[/TD]
[TD]56.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Protective Life ACH[/TD]
[TD]-56.97[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Valic ACH[/TD]
[TD]48.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Valic ACH[/TD]
[TD]-48.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Gerber ACH[/TD]
[TD]41.80[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Gerber ACH[/TD]
[TD]-41.80[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]S1 Savings ACH[/TD]
[TD]32.28[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]S1 Savings ACH[/TD]
[TD]-32.28[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]MetLife ACH[/TD]
[TD]29.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]MetLife ACH[/TD]
[TD]-29.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]21.84[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]-21.84[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]19.93[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-19.93[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]11.75[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-11.75[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]4.06[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Pru Select ACH[/TD]
[TD]-4.06[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]2.61[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Retirement Pen ACH[/TD]
[TD]-2.61[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]West Coast Life ACH[/TD]
[TD]2.40[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]West Coast Life ACH[/TD]
[TD]-2.40[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Comm Ck Deposit[/TD]
[TD]60,359.91[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]ES Comm Deposit[/TD]
[TD]-59,875.92[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Comm Ck Deposit[/TD]
[TD]-92.35[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09204100[/TD]
[TD]4406500000[/TD]
[TD]Neg Bal Ck 1320[/TD]
[TD]-391.64[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]NBD-Sales Management[/TD]
[TD]440650 Rep Fees-Other[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Insight Financial WR[/TD]
[TD]240,053.80[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]Insight Financial WR[/TD]
[TD]-240,053.80[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]NSCC ZBA Transfer[/TD]
[TD]186,085.23[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1102020000[/TD]
[TD]NSCC ZBA Transfer[/TD]
[TD]-186,085.23[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110202 Wells Fargo NSCC Settlement Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Comm ZBA Transfer[/TD]
[TD]419,766.20[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1104000000[/TD]
[TD]Comm ZBA Transfer[/TD]
[TD]-419,766.20[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110400 Wells Fargo Commission Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1102010000[/TD]
[TD]AP ZBA Transfer[/TD]
[TD]1,383.77[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110201 Wells Fargo Accounts Payable Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]AP ZBA Transfer[/TD]
[TD]-1,383.77[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1102020000[/TD]
[TD]NSCC Credit[/TD]
[TD]186,085.23[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110202 Wells Fargo NSCC Settlement Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]NSCC Monthly Billing[/TD]
[TD]38,760.21[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]NSCC Credit MF[/TD]
[TD]-164,242.89[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1305000000[/TD]
[TD]NSCC Credit INS[/TD]
[TD]-60,602.55[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]130500 Commissions Receivable-Non Clearing[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Interco Pmt from ICA[/TD]
[TD]547,723.76[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1389120000[/TD]
[TD]Interco Pmt from ICA[/TD]
[TD]-547,723.76[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]138912 A/R from affiliates-ICA[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Interco Pmt from IFC[/TD]
[TD]522,529.18[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1389110000[/TD]
[TD]Interco Pmt from IFC[/TD]
[TD]-522,529.18[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]138911 A/R from affiliates-INVEST[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Interco Pmt from NPH[/TD]
[TD]61,863.68[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1389000000[/TD]
[TD]Interco Pmt from NPH[/TD]
[TD]-61,863.68[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]138900 A/R from affiliates-NPH[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Wells Deposit[/TD]
[TD]895.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]2449000000[/TD]
[TD]JNL 300509058 Savage[/TD]
[TD]-395.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]244900 Accrued Marketing Reimbursements[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]2449000000[/TD]
[TD]TransAm 238335 Frattini[/TD]
[TD]-500.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]244900 Accrued Marketing Reimbursements[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Dividend Cap Sep 16 WR[/TD]
[TD]3,330.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1361000000[/TD]
[TD]Dividend Cap Sep 16 WR[/TD]
[TD]-3,330.00[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]136100 Sponsor Fees Receivable[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]2389300000[/TD]
[TD]Interco Pmt to SII[/TD]
[TD]238,031.89[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]238930 A/P to Affiliates-SII[/TD]
[/TR]
[TR]
[TD]TY920BNK1012[/TD]
[TD]920[/TD]
[TD]09200000[/TD]
[TD]1107010000[/TD]
[TD]Interco Pmt to SII[/TD]
[TD]-238,031.89[/TD]
[TD]10/12/2016[/TD]
[TD]BNKUNOPER[/TD]
[TD]Balance Sheet[/TD]
[TD]110701 Wells Fargo Operating Account[/TD]
[/TR]
</tbody>[/TABLE]


Not sure how to put in table.. please advise. Sorry.
 
Upvote 0
With your data, if I run the code, nothing happens. X is always 0.
Can you investigate and send a sample of data where it is clear what happens ?
 
Upvote 0
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Solved
vba to sum up each column for each employee on column (A)
Replies
6
Views
312
kvsrinivasamurthy
K
M
  • Question Question
Please help me to correct Excel VBA code!
Replies
1
Views
321
Minh Tuan VN
M
S
  • Question Question
VBA support : need to remove extra space
Replies
2
Views
171
sksanjeev786
S
rjplante
  • Solved
sort numbers with letters
2 3
Replies
24
Views
1K
Akuini
Akuini
Emka
  • Question Question
Web Scrap on Chrome via VBA
Replies
0
Views
101
Emka
Emka

Forum statistics

Threads
1,223,790
Messages
6,174,594
Members
452,574
Latest member
hang_and_bang

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top