Need some help in automating the formatting of shipping data

D

Dagonean

New Member
Joined
Nov 16, 2011
Messages
11
We get an export from our client (a .csv) that contains all that we need to both build the order(s) and then ship them to our clients' clients (well, usually that is). Anyway, I have set up 3 templates to manually go through the data and have it set up an export that I can get into UPS WorldShip, but now I am the only one that can ship this stuff, which isn't good.

I am attempting to automate the export as much as possible, so that my co-workers (or my bosses even) can ship these, but I'm both running into problems, and having trouble visualizing exactly HOW to get some of this done (I've ALWAYS had problems w/ arrays greater than 1 dimension). I've gotten a LOT of great stuff from different sites/message boards/the 2 books I've bought (Excel 2010 Bible and VBA and Macros: MS Excel 2010), and I've been able to modify some other examples I've found to do some useful things, but now I'm stumped.

I *THINK* I've gotten the logic down on how to box the pieces, based on some rules I figured out by doing this stuff by hand. We get orders with ~17 part numbers, which I have broken down into 4 types: type 1 has 12 part numbers that are all the same size & weight, and go into 2 different box sizes. BUT, then there is this... the SINGLE PACK holds one, and the TRIPLE PACK holds 1-3, tho we don't put one in it. That means that type 1 items have 3 box types (because the weight of the triple w/ 2 is different than the weight of the triple w/ 3). So, the logic for type 1's is: There can be only ONE single pack OR one triple pack containing 2 items, and as many triple packs containing 3 as needed (I have an arbitrary limit set at 20 atm, as the most needed so far has been 7). The type 2-4 have similar rules also.

One of the places I'm stumped at is the fact that since I haven't been able to figure out how to do an import into WorldShip to do a multiple piece shipment (not what I'm asking here), I need to be able to add lines and copy information for shipments that are multiple boxes. I've tried copying to another sheet entirely, but for some reason I can't get it to add extras to ones that need it. I then thought about trying to add the lines BEFORE copying to another sheet, but that's where I start having problems visualizing wth I'm doing. In the Box Logic module there are several subs I was in the process of trying, I just can't get my mind wrapped around keeping track of things (so I don't copy on top of a previously copied row, etc.).

(Note I use the advanced filter to get out the unique addresses before I do the above).

I've been trying to break up my sub's into smaller groups, so that I can more easily adapt them for the 2 international templates I need to get working (we ship on our clients UPS account(s), so we do US (domestic) on one account number, Canada on the domestic number (but with all the info for international/customs), and international on another account number (along w/ customs info).

I'm also pretty sure that a good bit of my coding could use some, erm, cleaning up? Prettifing? I know that I need to comment better, but that has always been something I've not been good at (blame it on starting in Basic back on a Atari 800 XL and IBM PCjr :p)

I have included a sample dataset (randomized and zeroed out to protect the innocent), but I've tried to keep the basics of it unchanged to give you an idea of what we get. This is a small order (done, shipped on Monday), as we seem to get 2-5 a week, ranging from 50ish rows to almost 200 per order, with a 3 day turn-around.

* ok, I tried to include a workbook, but can't post attachments. Ok, well, here's my VBA code, now just need to figure out how to post some sample data...

Code: 
' Trying to set up boxing logic for client
' This is not gonna be fun
'
' Put BoxLogic() on a button on info tab in some kind of step order w/ others to make easier for newbs
' Started:           11/06/2011
' Last modified:     11/17/2011

Option Explicit
Public i As Long, iCalc As Long                          ' i = for/next variable, iCalc = throwaway Long
Public iBoxTypeCount(2 To 250, 1 To 11) As Long          ' (Row #, Box Type)
Public iTotalBoxTypeCount(250, 4, 3) As Long             ' (Row #, Type (1,2,3,4), # in box (1-3 for most, 1-2 for type 2))
Public iX As Long, iY As Long, iZ As Long                ' all throwaway Longs
Public iCalc2 As Long, iTotalBoxes(2 To 250) As Long     ' iCalc2 throwaway, iTotalboxes = total boxes per address
Public iAddressItemTotals(2 To 250, 1 To 4) As Long      ' Total qty of item_id's for each unique address
Public iAddedRows(2 To 250) As Long, iI As Long                  ' might not need, can delete if not (range)
Public iAddressNumInBox(2 To 250, 1 To 11, 1 To 20) As Long ' (Row, Box Type, Package #)
Public iLastRow As Long, iNewLastRow As Long         ' iLastRow = Starting last row of unique addresses, iNewLastRow = iLastRow + any added rows

Sub BoxLogic()
    Application.ScreenUpdating = False
    
    Call ZeroOut2                                           ' Clear out box/total array's in case button is pressed more than 1x
    Call GetUnique                                          ' Get initial list of unique addresses
    Sheets("Extras1").Activate
    iLastRow = Range("F65536").End(xlUp).row                ' Find starting last row, data sent to us thus far no longer than 200 lines
    iNewLastRow = iLastRow
    
    With Sheets("Extras1")                                  'SUMIFS($AY$2:$AY$250,$BT$2:$BT$250,"=1",$BH$2:$BH$250,F2)
        For i = iLastRow To 2 Step -1
            For iX = 1 To 4
                iAddressItemTotals(i, iX) = Application.WorksheetFunction.SumIfs(.Range("AY2:AY250"), _
                    .Range("BT2:BT250"), "=" & iX, .Range("BH2:BH250"), .Range("F" & i).Value)
            Next iX
        Next i
    End With
    
    For i = iLastRow To 2 Step -1
        Call RowBoxCount
        For iZ = 1 To 11
            iTotalBoxes(i) = iTotalBoxes(i) + iBoxTypeCount(i, iZ)
        Next iZ
        
        If iTotalBoxes(i) > 1 Then                          ' Tells AddLines() sub how many rows to add ** AddLines() not added yet **
            Range("R" & i) = iTotalBoxes(i) - 1
            iNewLastRow = iNewLastRow + iTotalBoxes(i) - 1  ' update newlastrow + (n-1)
        Else
            Range("R" & i) = 0                              ' give it a value
        End If
    Next i
    
    Call CopyToExtras2Tab

    Application.ScreenUpdating = True
End Sub

Sub RowBoxCount()                                           ' Sub to get boxes for each Row
    If iAddressItemTotals(i, 1) > 0 Then
        Call Type1                                          ' Part numbers 2,3,4,24,32,33,34,35,36,40,42,45
    End If
    If iAddressItemTotals(i, 2) > 0 Then
        Call Type2                                          ' Part number 43
    End If
    If iAddressItemTotals(i, 3) > 0 Then
        Call Type3                                          ' Part numbers 64,108
    End If
    If iAddressItemTotals(i, 4) > 0 Then
        Call Type4                                          ' Part Numbers 63,106
    End If
End Sub

Sub Type1()                                                 ' (x, 1, x) for Type 1s
    Call ZeroOut
    iCalc = iAddressItemTotals(i, 1) Mod 3                  ' Get remainder if qty / 3
    iCalc2 = Application.WorksheetFunction.Quotient(iAddressItemTotals(i, 1), 3)          ' Get quotient of qty / 3
    
    If iAddressItemTotals(i, 1) = 4 Then                    ' If qty = 4, do 2 and 2, not 1 and 3, per my boss
        iBoxTypeCount(i, 1) = 0
        iBoxTypeCount(i, 2) = 2
        iBoxTypeCount(i, 3) = 0
        iAddressNumInBox(i, 1, 1) = 0
        iAddressNumInBox(i, 2, 1) = 2
        iAddressNumInBox(i, 2, 2) = 2
        iAddressNumInBox(i, 3, 1) = 0
        Exit Sub
    End If
    
    Select Case iCalc                                       ' Per shipment (row), can only have 1 box of 1 OR 1 box of 2, max, not 1 of ea.
        Case 2
            iX = 0                                          ' Box type 1, 1/1
            iY = 1                                          ' Box type 2, 2/3
        Case 1
            iX = 1                                          ' Box type 1, 1/1
            iY = 0                                          ' Box Type 2, 2/3
    End Select
    iBoxTypeCount(i, 1) = iX
    iBoxTypeCount(i, 2) = iY
    iBoxTypeCount(i, 3) = iCalc2
    For iZ = 1 To 3
        Select Case iZ
            Case 1
                iAddressNumInBox(i, 1, 1) = iX             ' max one box w/ qty 1, 0 w/ qty 2
            Case 2
                iAddressNumInBox(i, 2, 1) = iY             ' max one box w/ qty 2, 0 w/ qty 1
            Case 3
                For iI = 1 To iBoxTypeCount(i, 3)          ' no "real" upper limit on qty 3 boxes, max is 20 atm
                    iAddressNumInBox(i, 3, iI) = 3
                Next iI
        End Select
    Next iZ
End Sub

Sub Type2()                                                 ' (x, 2, x) for Type 2s
    Call ZeroOut
    iCalc = iAddressItemTotals(i, 2) Mod 2                  ' Get remainder of qty / 2
    iCalc2 = Application.WorksheetFunction.Quotient(iAddressItemTotals(i, 2), 2)          ' Get quotient of qty / 2
    iBoxTypeCount(i, 4) = iCalc                             ' Box Type 4, 1/1, can only have max 1 box of 1
    iBoxTypeCount(i, 10) = iCalc2                           ' Box Type 10, 2/2
    For iZ = 1 To 2
        Select Case iZ
            Case 1
                iAddressNumInBox(i, 4, 1) = iCalc          ' max one box w/ qty 1
            Case 2
                iAddressNumInBox(i, 10, 2) = iCalc2        ' no "real" upper limit on qty 2 boxes, max is 20 atm
        End Select
    Next iZ
End Sub

Sub Type3()                                                 ' (x, 3, x) for Type 3s
    Call ZeroOut
    iCalc = iAddressItemTotals(i, 3) Mod 3                  ' Get remainder of qty / 3
    iCalc2 = Application.WorksheetFunction.Quotient(iAddressItemTotals(i, 3), 3)          ' Get quotient of qty / 3
    
    If iAddressItemTotals(i, 1) = 4 Then                    ' If qty = 4, do 2 and 2, not 1 and 3, per my boss
        iBoxTypeCount(i, 7) = 0
        iBoxTypeCount(i, 8) = 2
        iBoxTypeCount(i, 9) = 0
        iAddressNumInBox(i, 7, 0) = 0
        iAddressNumInBox(i, 8, 1) = 2
        iAddressNumInBox(i, 8, 2) = 2
        iAddressNumInBox(i, 9, 0) = 0
        Exit Sub
    End If
    
    Select Case iCalc                                       ' can only have 1 box of 1 OR 1 box of 2 per shipment (row), max
        Case 2
            iX = 0                                          ' Box type 7, 1/3
            iY = 1                                          ' Box type 8, 2/3
        Case 1
            iX = 1                                          ' Box type 7, 1/3
            iY = 0                                          ' Box Type 8, 2/3
    End Select
    iBoxTypeCount(i, 7) = iX
    iBoxTypeCount(i, 8) = iY
    iBoxTypeCount(i, 9) = iCalc2                            ' Box Type 9 (3/3)
    For iZ = 1 To 3
        Select Case iZ
            Case 1
                iAddressNumInBox(i, 7, 1) = iX
            Case 2
                iAddressNumInBox(i, 8, 1) = iY
            Case 3                                          ' No "real" limit on # of boxes containing 3, limit is 20 atm
                For iI = 1 To iBoxTypeCount(i, 3)
                    iAddressNumInBox(i, 9, iI) = 3
                Next iI
        End Select
    Next iZ
End Sub

Sub Type4()                                                 ' (x, 4, x) for Type 4s
    Call ZeroOut
    iCalc = iAddressItemTotals(i, 4) Mod 3                  ' Get remainder of qty / 3
    iCalc2 = Application.WorksheetFunction.Quotient(iAddressItemTotals(i, 4), 3)          ' get quotient of qty / 3
    
    Select Case iCalc                                       ' can only have 1 box of 1 OR 1 box of 2, max per shipment (row)
        Case 2
            iX = 0                                          ' Box type 5, 1/1
            iY = 1                                          ' Box type 6, 2/3
        Case 1
            iX = 1                                          ' Box type 5, 1/1
            iY = 0                                          ' Box Type 6, 2/3
    End Select
    iBoxTypeCount(i, 5) = iX
    iBoxTypeCount(i, 6) = iY
    iBoxTypeCount(i, 11) = iCalc2                           ' Box Type 11, 3/3
    For iZ = 1 To 3
        Select Case iZ
            Case 1
                iAddressNumInBox(i, 5, 1) = iX
            Case 2
                iAddressNumInBox(i, 6, 1) = iY
            Case 3                                          ' no "real" limit of boxes of 3, limit is 20 atm
            For iI = 1 To iBoxTypeCount(i, 3)
                iAddressNumInBox(i, 11, iI) = 3
            Next iI
        End Select
    Next iZ
End Sub

Sub GetUnique()
'
' GetUnique Macro
' Get unique addresses and put them somewhere else
' From Macro Recorder, could prolly be optimized a bit
    Sheets("Extras1").Activate
    Range("Bh1:Bh250").AdvancedFilter Action:=xlFilterCopy, CopyToRange:= _
        Columns("F:F"), Unique:=True
End Sub
Sub ZeroOut()
    iX = 0
    iY = 0
    iZ = 0
    iCalc = 0
    iCalc2 = 0
End Sub
Sub ZeroOut2()
    For i = 2 To 250
        For iI = 1 To 4
            iAddressItemTotals(i, iI) = 0
        Next iI
        For iI = 1 To 4
            For iX = 1 To 3
                iTotalBoxTypeCount(i, iI, iX) = 0
            Next iX
        Next iI
        iTotalBoxes(i) = 0
        For iI = 1 To 11
            For iX = 1 To 20
                iAddressNumInBox(i, iI, iX) = 0
            Next iX
        Next iI
    Next i
End Sub
Sub CopyToExtras2Tab()
    Dim iExtra As Long, iRowNumber As Long, iExxtra As Long, iXxx As Long, iXx As Long
    iRowNumber = 2
    
    Do
        iXx = iRowNumber + iExtra
        Sheets("Extras1").Range("A" & iRowNumber & ":Q" & iRowNumber).Copy
        Sheets("Extras2").Range("A" & iXx).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
            SkipBlanks:=False, Transpose:=False
        
        If Sheets("Extras1").Range("R" & iRowNumber).Value > 0 Then
            iExxtra = Sheets("Extras1").Range("R" & iXx).Value
            For iXxx = 1 To iExxtra
                iExtra = iExtra + 1
                iXx = iRowNumber + iExtra
                Sheets("Extras1").Range("A" & iRowNumber & ":Q" & iRowNumber).Copy
                Sheets("Extras2").Range("A" & iXx).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
                    SkipBlanks:=False, Transpose:=False
            Next iXxx
        End If
        iRowNumber = iRowNumber + 1
    Loop While iRowNumber <= iLastRow
End Sub

Sub AddLines()                                      ' getting lost trying to code this :/
    Dim iExtra As Long, iDun As Long                ' supposed to do: read column r value and add "x" # of rows below it
    iExtra = 0                                      ' and copy info into the inserted row(s). Once this is done, can call the above
    iDun = 0                                        ' sub (copy to extras 2) and then fill in missing stuffs.
    
    For i = 2 To iLastRow
        iDun = i + iExtra
        With Sheets("Extras1")
            If .Range("R" & iDun).Value > 0 Then
                For iX = 1 To .Range("R" & iDun).Value
                    .Range("R" & iDun + 1).EntireRow.Select
                    Selection.Insert Shift:=xlDown
                    .Range("A" & iDun & ":Q" & iDun).Copy
                    .Range("A" & iDun + 1).PasteSpecial Paste:=xlPasteValues, _
                    Operation:=xlNone, SkipBlanks:=False, Transpose:=False
                    iExtra = iExtra + 1
                Next iX
            End If
        End With
    Next i
End Sub
Sub AddingLinesNStuff() ' another try at rewriting
    Dim iFLastRow As Long, iNewFLastRow As Long, iRow As Long, iAdded As Long
    Sheets("Extras1").Activate
    iFLastRow = Range("F65536").End(xlUp).row
    iNewFLastRow = iFLastRow
    iRow = 0
    iAdded = 0
    For i = 2 To 250
        iAddedRows(i) = 0
    Next i
    
    For i = 2 To iFLastRow
        iRow = i + iAdded
        With Sheets("Extras1")
            .Range("A" & i & ":Q" & i).Copy
            Sheets("Extras2").Range("A" & iRow).PasteSpecial Paste:=xlPasteValues, _
                Operation:=xlNone, SkipBlanks:=False, Transpose:=False
            If .Range("R" & i).Value > 1 Then
                For iX = 1 To .Range("R" & i).Value
                    .Range("A" & i & ":Q" & i).Copy
                    Sheets("Extras2").Range("A" & iRow + iX).PasteSpecial Paste:=xlPasteValues, _
                        Operation:=xlNone, SkipBlanks:=False, Transpose:=False
                    iAdded = iAdded + 1
                    iAddedRows(iRow + iX) = 1
                Next iX
            End If
        End With
    Next i
    Call MissingStuffFillIn(iAdded)
End Sub
Sub MissingStuffFillIn(iAddedRows As Long) ' not even close to done, I'm just lost
    Dim iLastRowB As Long
    Sheets("Extras2").Activate
    iLastRowB = Range("B65536").End(xlUp).row
    'iAddressNumInBox(2 To 250, 1 To 11, 1 To 20) As Long ' (Row, Box Type, Package #)
    
   With Sheets("Extras2")
        For i = 2 To iLastRowB
          For iX = 1 To 11
              For iY = 1 To 20
                  If iAddressNumInBox(i, iX, iY) > 0 Then
                    .Range("P" & i).Value = iAddressNumInBox(i, iX, iY)
    
End Sub
Any help is greatly appreciated, or even a nudge in the direction of something that I can read to figure this stuff out. I've been on a crash course on this since September, so I've learned quite a bit, but I know I still have a good ways to go.
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
Sort by date Sort by votes
Here is the pasted in information (on the Paste tab) that will be worked with. The order_id field is the part number of the items. (and I know that the city/states might not make sense, they're just randomized. I figure out multiples to a single address by starting at the address1 field). Also, the number in the Tracking_number column is actually our uniqueID, used to pull the tracking number out of the UPS End of Day export in another workbook. I just need to rename the field (been too busy trying to make the rest of this work first tho).

The tabs I have (at the moment are as follows).


  • Info (instructions/notes, and buttons for the various steps to run vba code.
  • Paste (where the original info is pasted into, and the user can change the shipping method if necessary)
  • Data (where my in sheet formulas did vlookups and whatnot to format the data, when done by hand. Left in until I get the auto part working)
  • Tables (lookups and informational tables, and 2 user input fields: our WO number and Yes/No dropdown box for deciding if it needs to ship as third party)
  • Extra (hidden tab that does some behind the scenes work)
  • Extras1 (Holds the initial list of unique addresses from Advanced filter)
  • Extras2 (where to put the new list, adding extra rows as needed)
  • Auto-Data (going to be the page that contains all the shipping information, similar to data page above)
Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th><th>S</th><th>T</th><th>U</th><th>V</th><th>W</th><th>X</th><th>Y</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">time_stamp</td><td style="font-weight: bold;;">order_id</td><td style="font-weight: bold;;">order_item_id</td><td style="font-weight: bold;;">item_id</td><td style="font-weight: bold;;">Qty</td><td style="font-weight: bold;;">description</td><td style="font-weight: bold;;">text</td><td style="font-weight: bold;;">year</td><td style="font-weight: bold;;">gender</td><td style="font-weight: bold;;">country</td><td style="font-weight: bold;;">color</td><td style="font-weight: bold;;">firm_name</td><td style="font-weight: bold;;">customer_name</td><td style="font-weight: bold;;">address_1</td><td style="font-weight: bold;;">address_2</td><td style="font-weight: bold;;">city</td><td style="font-weight: bold;;">state_code</td><td style="font-weight: bold;;">postal_code</td><td style="font-weight: bold;;">country1</td><td style="font-weight: bold;;">phone</td><td style="font-weight: bold;;">email_1</td><td style="font-weight: bold;;">Tracking_Numbers</td><td style="font-weight: bold;;">address_3</td><td style="font-weight: bold;;">num_in_box</td><td style="font-weight: bold;;">Shipping_method</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43987</td><td style="text-align: right;;">53634</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Fourth St, Ste 0000</td><td style="text-align: right;;">
</td><td style=";">Durham</td><td style=";">AL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-017</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44018</td><td style="text-align: right;;">53673</td><td style="text-align: right;;">35</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 W Madison St, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Houston</td><td style=";">MO</td><td style=";">00000-0000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-021</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43339</td><td style="text-align: right;;">52831</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 E Queen St</td><td style="text-align: right;;">
</td><td style=";">Houston</td><td style=";">CA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-030</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44006</td><td style="text-align: right;;">53653</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">F</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Brickell Ave, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Cleveland</td><td style=";">VA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-024</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44000</td><td style="text-align: right;;">53647</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 N Fourth Ave</td><td style="text-align: right;;">
</td><td style=";">Columbus</td><td style=";">AZ</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-029</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43959</td><td style="text-align: right;;">53602</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Lady St, Sixth Fl</td><td style="text-align: right;;">
</td><td style=";">White Plains</td><td style=";">CA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-042</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43979</td><td style="text-align: right;;">53626</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Forest Ave</td><td style="text-align: right;;">
</td><td style=";">Scottsdale</td><td style=";">NM</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-040</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43967</td><td style="text-align: right;;">53613</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Tysons Blvd, Ste 000</td><td style="text-align: right;;">
</td><td style=";">McLean</td><td style=";">FL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-026</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43967</td><td style="text-align: right;;">53614</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Tysons Blvd, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Sunrise</td><td style=";">NJ</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-036</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43994</td><td style="text-align: right;;">53641</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 N St, Bldg 00</td><td style="text-align: right;;">
</td><td style=";">Denver</td><td style=";">WI</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-015</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43945</td><td style="text-align: right;;">53580</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style=";">US</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 E St Julian St</td><td style="text-align: right;;">
</td><td style=";">Zionsville</td><td style=";">SC</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">102912-008</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44022</td><td style="text-align: right;;">53677</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 N Main St, Ste 0</td><td style="text-align: right;;">
</td><td style=";">Cherry Hill</td><td style=";">OR</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-010</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43988</td><td style="text-align: right;;">53635</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Main St, Ste 0000</td><td style="text-align: right;;">
</td><td style=";">Baltimore</td><td style=";">IN</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-037</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43970</td><td style="text-align: right;;">53617</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 N First St</td><td style="text-align: right;;">
</td><td style=";">Honolulu</td><td style=";">NY</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-005</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43990</td><td style="text-align: right;;">53637</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Cedarwood Rd</td><td style="text-align: right;;">
</td><td style=";">Vienna</td><td style=";">CT</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-035</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43972</td><td style="text-align: right;;">53619</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">00 W Middle Ln</td><td style="text-align: right;;">
</td><td style=";">Dallas</td><td style=";">LA</td><td style=";">00000-0000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-002</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44026</td><td style="text-align: right;;">53681</td><td style="text-align: right;;">64</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">Black</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Gaskins Rd, Ste 0</td><td style="text-align: right;;">
</td><td style=";">New Orleans</td><td style=";">NJ</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-043</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">###</td><td style="text-align: right;;">42681</td><td style="text-align: right;;">51999</td><td style="text-align: right;;">64</td><td style="text-align: right;;">4</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">Rosewood</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Main Pl Tower</td><td style=";">000 Main St</td><td style=";">Auburn</td><td style=";">FL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-044</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43936</td><td style="text-align: right;;">53563</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Wacker Dr, Ste 0000</td><td style="text-align: right;;">
</td><td style=";">New Bern</td><td style=";">IL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-038</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43936</td><td style="text-align: right;;">53563</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Wacker Dr, Ste 0000</td><td style="text-align: right;;">
</td><td style=";">Millburn</td><td style=";">NJ</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-039</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43996</td><td style="text-align: right;;">53643</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">F</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 Fifth Ave S</td><td style="text-align: right;;">
</td><td style=";">Rocky Mount</td><td style=";">MO</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-001</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43996</td><td style="text-align: right;;">53643</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 Fifth Ave S</td><td style="text-align: right;;">
</td><td style=";">Raleigh</td><td style=";">MO</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-011</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43978</td><td style="text-align: right;;">53625</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 Porsche Way, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Pearland</td><td style=";">AL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-006</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43981</td><td style="text-align: right;;">53628</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">0000 N. Summit Ave</td><td style="text-align: right;;">
</td><td style=";">Coral Gables</td><td style=";">MD</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-003</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43997</td><td style="text-align: right;;">53644</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 Knollwood Rd, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Houston</td><td style=";">MO</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-014</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43962</td><td style="text-align: right;;">53606</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Seventh St, Ste 000</td><td style="text-align: right;;">
</td><td style=";">St Louis</td><td style=";">TX</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-007</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44023</td><td style="text-align: right;;">53678</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">F</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 S Oranage Ave, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Wichita</td><td style=";">PA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-023</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43971</td><td style="text-align: right;;">53618</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 Ct Sq, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Roanoke</td><td style=";">PA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-028</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43999</td><td style="text-align: right;;">53646</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 E Genesee St</td><td style="text-align: right;;">
</td><td style=";">Seattle</td><td style=";">AL</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-027</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43980</td><td style="text-align: right;;">53627</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah</td><td style=";">000 W BRdway, Ste 0000</td><td style="text-align: right;;">
</td><td style=";">Las Vegas</td><td style=";">MO</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-032</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43989</td><td style="text-align: right;;">53636</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">F</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">000 Campus Commons Rd, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Crossett</td><td style=";">CA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-034</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">33</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44017</td><td style="text-align: right;;">53671</td><td style="text-align: right;;">35</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">0000 Oakhurst Cir</td><td style="text-align: right;;">
</td><td style=";">Houston</td><td style=";">VA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-022</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43948</td><td style="text-align: right;;">53585</td><td style="text-align: right;;">64</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">Rosewood</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">000 W Myrtle St</td><td style="text-align: right;;">
</td><td style=";">Raleigh</td><td style=";">AZ</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-045</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">35</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43986</td><td style="text-align: right;;">53633</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Bank of America Plaza, Ste 0000</td><td style=";">000 S Tryon St</td><td style=";">Chicago</td><td style=";">CA</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-004</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">36</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43998</td><td style="text-align: right;;">53645</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">IDS Ctr, Ste 000</td><td style=";">00 S Eighth St</td><td style=";">Lexington</td><td style=";">NM</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-009</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">37</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43960</td><td style="text-align: right;;">53603</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Miami Tower, Ste 0000</td><td style=";">000 SE Second St</td><td style=";">Harrisonburg</td><td style=";">FL</td><td style=";">00000-0000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-018</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">38</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43985</td><td style="text-align: right;;">53632</td><td style="text-align: right;;">43</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth E Main St, Ste 000</td><td style="text-align: right;;">
</td><td style=";">Tucson</td><td style=";">NJ</td><td style=";">00000-0000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-041</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">39</td><td style="text-align: right;;">###</td><td style="text-align: right;;">43991</td><td style="text-align: right;;">53638</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth Oxford Centre, 00th Fl</td><td style=";">000 Grant St</td><td style=";">Everett</td><td style=";">WI</td><td style=";">00000-0000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-031</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">40</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44004</td><td style="text-align: right;;">53651</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">F</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth Datran Ctr, Ste 0000</td><td style=";">0000 S Dadeland Blvd</td><td style=";">Charleston</td><td style=";">SC</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-013</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">41</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44004</td><td style="text-align: right;;">53651</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth Datran Ctr, Ste 0000</td><td style=";">0000 S Dadeland Blvd</td><td style=";">Traverse City</td><td style=";">OR</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-016</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">42</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44004</td><td style="text-align: right;;">53651</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth Datran Ctr, Ste 0000</td><td style=";">0000 S Dadeland Blvd</td><td style=";">Midlothian</td><td style=";">IN</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-019</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">43</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44004</td><td style="text-align: right;;">53651</td><td style="text-align: right;;">33</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">Zeroth Datran Ctr, Ste 0000</td><td style=";">0000 S Dadeland Blvd</td><td style=";">Kansas City</td><td style=";">NY</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-020</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr><tr><td style="color: #161120;text-align: center;">44</td><td style="text-align: right;;">###</td><td style="text-align: right;;">44021</td><td style="text-align: right;;">53676</td><td style="text-align: right;;">42</td><td style="text-align: right;;">1</td><td style=";">blah</td><td style=";">blah</td><td style="text-align: right;;">6985</td><td style=";">M</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style=";">blah blah blah</td><td style="text-align: right;;">
</td><td style=";">U.S. Steel Tower, 00th Fl</td><td style=";">000 Grant St</td><td style=";">Collegeville</td><td style=";">CT</td><td style="text-align: right;;">00000</td><td style="text-align: right;;">
</td><td style=";">000-000-0000</td><td style="text-align: right;;">
</td><td style=";">102912-025</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td><td style="text-align: right;;">
</td></tr></tbody></table>
Paste​
 
Last edited:
Upvote 0
Well, hopefully this link to the spreadsheet works. Haven't tried it yet, but it's the entire workbook (minus a few superfluous pages). It's on rapidshare, since I don't know a lot about file hosting online (not really my thing).

If anyone has any questions, or needs me to explain more about what I'm doing/have done/want to do, let me know. I'm not asking anyone here to write/re-write this stuff for me, I just need some pointers or a way to logically add rows based on how many boxes are shipping. I *THINK* I can get the rest.

J
 
Upvote 0
Well, I seem to have figured out the copying and adding lines bit. Took me a bit, but I rewrote my code, and after figuring out how to make it NOT add blank lines (that part wasn't fun), I thought I'd post it here. Maybe it could help someone.

I've found that, even though I really hate having to type long variable names over and over, it helps to REALLY name them descriptively. At least this time, it's helped me keep everything visualized.

Code: 
ub AddLines()                                                              ' working, no blank lines
    Dim iAddedRows As Long, iLastRow As Long, blnTripMeter As Boolean
    Dim iExtras1RowCount As Long, iExtras2CurrentRow As Long
    
    iLastRow = Sheets("Extras1").Range("F65536").End(xlUp).Row
    iAddedRows = 0
    
    For iExtras1RowCount = 2 To iLastRow
        blnTripMeter = False
        iExtras2CurrentRow = iExtras1RowCount + iAddedRows
        With Sheets("Extras1")
            .Range("A" & iExtras1RowCount & ":Q" & iExtras1RowCount).Copy
            Sheets("Extras2").Range("A" & iExtras2CurrentRow & ":Q" & iExtras2CurrentRow). _
                PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, _
                Transpose:=False
            If .Range("R" & iExtras1RowCount).Value > 0 Then
                For i = 0 To .Range("R" & iExtras1RowCount).Value
                    iExtras2CurrentRow = iExtras1RowCount + iAddedRows
                    .Range("A" & iExtras1RowCount & ":Q" & iExtras1RowCount).Copy
                    Sheets("Extras2").Range("A" & iExtras2CurrentRow & ":Q" & iExtras2CurrentRow) _
                        .PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, _
                        Transpose:=False
                    iAddedRows = iAddedRows + 1
                    blnTripMeter = True
                Next i
            End If
        End With
        If blnTripMeter = True And iAddedRows >= 1 Then              ' makes it so no blank lines after set of lines added
            iAddedRows = iAddedRows - 1                              ' might not need AddedRows check, but there anyway
        End If
    Next iExtras1RowCount
End Sub
Extras1 tab (data)

Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style=";">First</td><td style=";">Second</td><td style=";">Third</td><td style=";">Fourth</td><td style=";">Fifth</td><td style=";">Sixth</td><td style=";">Seventh</td><td style=";">Eighth</td><td style=";">Ninth</td><td style=";">Tenth</td><td style=";">Eleventh</td><td style=";">Twelfth</td><td style=";">Thirteenth</td><td style=";">Fourteenth</td><td style=";">Fifteenth</td><td style=";">Sixteenth</td><td style=";">Seventeenth</td><td style=";">Rows to add</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">0</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">1</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">2</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">0</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">4</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">2</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">1</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">3</td></tr></tbody></table>
Extras1​

Extras2 tab (output)

Excel 2010<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB" cellpadding="2.5px"><colgroup><col style="background-color: #DAE7F5" width="25px"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th><th>N</th><th>O</th><th>P</th><th>Q</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style=";">First</td><td style=";">Second</td><td style=";">Third</td><td style=";">Fourth</td><td style=";">Fifth</td><td style=";">Sixth</td><td style=";">Seventh</td><td style=";">Eighth</td><td style=";">Ninth</td><td style=";">Tenth</td><td style=";">Eleventh</td><td style=";">Twelfth</td><td style=";">Thirteenth</td><td style=";">Fourteenth</td><td style=";">Fifteenth</td><td style=";">Sixteenth</td><td style=";">Seventeenth</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td><td style="text-align: right;;">1</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td><td style="text-align: right;;">2</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td><td style="text-align: right;;">3</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td><td style="text-align: right;;">4</td></tr><tr><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td><td style="text-align: right;;">5</td></tr><tr><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td><td style="text-align: right;;">6</td></tr><tr><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td></tr><tr><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td></tr><tr><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td><td style="text-align: right;;">7</td></tr><tr><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td></tr><tr><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td><td style="text-align: right;;">8</td></tr><tr><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td></tr><tr><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td></tr><tr><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td></tr><tr><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td><td style="text-align: right;;">9</td></tr></tbody></table>
Extras2​
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Unique pairs from a single column (VBA)
Replies
3
Views
282
StephenCrump
S
Tigron
  • Solved
VBA Runtime Error when Selecting Dropdown List
2 3 4
Replies
31
Views
2K
Tigron
Tigron
rjplante
  • Solved
sort numbers with letters
2 3
Replies
24
Views
319
Akuini
Akuini
SeniorNewbie
  • Solved
Need the first line of the VBA code of all my UDF
Replies
3
Views
63
Domenic
D
M
  • Solved
Need help modify to pick any first number of my choice
Replies
6
Views
275
motilulla
M

Forum statistics

Threads
1,215,059
Messages
6,122,917
Members
449,093
Latest member
dbomb1414

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