Split up ranges into smaller ranges into new rows

R

rostar99

New Member
Joined
Apr 8, 2013
Messages
5
Hi Everyone,
I currently have a large number of records to process that contain some large control number ranges that need to be broken up into smaller ranges with new rows created below for the new ranges. All the other columns of data need to copy down and a separate sequential batch number generated for all of the rows.
Raw Data:
Excel 2007
ABCDEFGHIJKLMNOPQRST
order numberCopy numberprocess dateFileset SegmentPlan NumberPlan NameTotal PackagesTotal SheetsTotal ImagesDivertsDestroyedControl Number RangeStock Code 1Count of Stock Code 1Stock Code 2Count of Stock Code 2Stock Code 3Count of Stock Code 3Stock Code 4Count of Stock Code 4
A09O'TOOLS AUTO, INC.1000001-1034814UPDATE Z
A091034815-1034816

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]34814[/TD]
[TD="align: right"]69799[/TD]
[TD="align: right"]139598[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"]34814[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]20130405[/TD]

[TD="align: right"]154730[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1​

Final spreadsheet:
Excel 2007
ABCDEFGHIJKLMNOPQR
Order numberCopy numberBatch Numberprocess dateFileset SegmentPlan NumberPlan NameTotal PackagesTotal SheetsTotal ImagesDivertsDestroyedControl NumberStartControl NumberEndStock Code 1Stock Code 2Stock Code 3Stock Code 4
1-01A09O'TOOLS AUTO, INC.UPDATE Z
1-02A09O'TOOLS AUTO, INC.UPDATE Z
1-03A09O'TOOLS AUTO, INC.UPDATE Z
1-04A09O'TOOLS AUTO, INC.UPDATE Z
1-05A09O'TOOLS AUTO, INC.UPDATE Z
1-06A09O'TOOLS AUTO, INC.UPDATE Z
1-07A09O'TOOLS AUTO, INC.UPDATE Z
1-08A09O'TOOLS AUTO, INC.UPDATE Z
1-09A09O'TOOLS AUTO, INC.UPDATE Z
1-10A09O'TOOLS AUTO, INC.UPDATE Z
1-11A09O'TOOLS AUTO, INC.UPDATE Z
1-12A09O'TOOLS AUTO, INC.UPDATE Z
1-13A09O'TOOLS AUTO, INC.UPDATE Z
1-14A09O'TOOLS AUTO, INC.UPDATE Z
1-15A09O'TOOLS AUTO, INC.UPDATE Z
1-16A09O'TOOLS AUTO, INC.UPDATE Z
1-17A09O'TOOLS AUTO, INC.UPDATE Z
1-18A09O'TOOLS AUTO, INC.UPDATE Z
1-19A09

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1000001[/TD]
[TD="align: right"]1002000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1002001[/TD]
[TD="align: right"]1004000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1004001[/TD]
[TD="align: right"]1006000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1006001[/TD]
[TD="align: right"]1008000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1008001[/TD]
[TD="align: right"]1010000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1010001[/TD]
[TD="align: right"]1012000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1012001[/TD]
[TD="align: right"]1014000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1014001[/TD]
[TD="align: right"]1016000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1016001[/TD]
[TD="align: right"]1018000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1018001[/TD]
[TD="align: right"]1020000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1020001[/TD]
[TD="align: right"]1022000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1022001[/TD]
[TD="align: right"]1024000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1024001[/TD]
[TD="align: right"]1026000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1026001[/TD]
[TD="align: right"]1028000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1028001[/TD]
[TD="align: right"]1030000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1030001[/TD]
[TD="align: right"]1032000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]2000[/TD]
[TD="align: right"]4000[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1032001[/TD]
[TD="align: right"]1034000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]105883[/TD]

[TD="align: right"]814[/TD]
[TD="align: right"]1799[/TD]
[TD="align: right"]3598[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1034001[/TD]
[TD="align: right"]1034814[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]20130405[/TD]

[TD="align: right"]154730[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1034815[/TD]
[TD="align: right"]1034816[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet2​

I am thinking of writing a macro to split up the ranges and add the rows but am unsure how to do this. Any help would be greatly appreciated.

Thanks,
Bob:)
Excel 2007 Windows 7 32 bit
 
Last edited:

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Sort by date Sort by votes
Re: Help creating macro to Split up number ranges into smaller number ranges into new rows

Hi everyone,
I need to split up records that have greater than 2000 in the control number range column. I have over 75,000 records to manipulate so any help would be appreciated. Here is the data sheet and desired result sheet.
Excel 2007
ABCDEFGHIJKL
order numberCopy numberPlan NumberPlan NameStock Code 1Stock Code 2Stock Code 3Stock Code 4
O'TOOLS AUTO, INC.UPDATE Z
1034815-1034816

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="bgcolor: #DBEEF3"]Total Packages[/TD]
[TD="bgcolor: #DBEEF3"]Total Sheets[/TD]
[TD="bgcolor: #DBEEF3"]Total Images[/TD]
[TD="bgcolor: #FFFF00"]Control Number Range[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]34814[/TD]
[TD="bgcolor: #DBEEF3, align: right"]69799[/TD]
[TD="bgcolor: #DBEEF3, align: right"]139598[/TD]
[TD="bgcolor: #FFFF00"]1000001-1034814[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]154730[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1​



The control number range in "Sheet1" (highlighted in yellow) represents the numbers of the individual packages for each record . The first record has 34814 packages and a control number range of 1000001-1034814. As this is greater than 2000 it must be broken up into ranges of 2000 ( start 1000001 end 1002000, start 1002001 end 1004000, etc). The Total Package, Total Sheets, and Total Images are also split up (highlighted in blue). If control number range and packages is equal to or less than 2000 then that row gets copied over to the other sheet with no additional rows and the the control number range number just gets split into a start and end control number (1034815-1034816 changes to start 1034815 end 1034816). The batch number is simply the first digit of the control number "1" combined with the row number(-01, -02 etc.).

Excel 2007
ABCDEFGHIJKLMN
Order numberCopy numberBatch NumberPlan NumberPlan NameStock Code 1Stock Code 2Stock Code 3Stock Code 4
1-01O'TOOLS AUTO, INC.UPDATE Z
1-02O'TOOLS AUTO, INC.UPDATE Z
1-03O'TOOLS AUTO, INC.UPDATE Z
1-04O'TOOLS AUTO, INC.UPDATE Z
1-05O'TOOLS AUTO, INC.UPDATE Z
1-06O'TOOLS AUTO, INC.UPDATE Z
1-07O'TOOLS AUTO, INC.UPDATE Z
1-08O'TOOLS AUTO, INC.UPDATE Z
1-09O'TOOLS AUTO, INC.UPDATE Z
1-10O'TOOLS AUTO, INC.UPDATE Z
1-11O'TOOLS AUTO, INC.UPDATE Z
1-12O'TOOLS AUTO, INC.UPDATE Z
1-13O'TOOLS AUTO, INC.UPDATE Z
1-14O'TOOLS AUTO, INC.UPDATE Z
1-15O'TOOLS AUTO, INC.UPDATE Z
1-16O'TOOLS AUTO, INC.UPDATE Z
1-17O'TOOLS AUTO, INC.UPDATE Z
1-18O'TOOLS AUTO, INC.UPDATE Z
1-19

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="bgcolor: #DBEEF3"]Total Packages[/TD]
[TD="bgcolor: #DBEEF3"]Total Sheets[/TD]
[TD="bgcolor: #DBEEF3"]Total Images[/TD]
[TD="bgcolor: #FFFF00"]Control NumberStart[/TD]
[TD="bgcolor: #FFFF00"]Control NumberEnd[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1000001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1002000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1002001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1004000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1004001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1006000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1006001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1008000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1008001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1010000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1010001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1012000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1012001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1014000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1014001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1016000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1016001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1018000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1018001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1020000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1020001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1022000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1022001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1024000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1024001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1026000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1026001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1028000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1028001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1030000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1030001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1032000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]2000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]4000[/TD]
[TD="bgcolor: #DBEEF3, align: right"]8000[/TD]
[TD="bgcolor: #FFFF00, align: right"]1032001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1034000[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]105883[/TD]

[TD="bgcolor: #DBEEF3, align: right"]814[/TD]
[TD="bgcolor: #DBEEF3, align: right"]1799[/TD]
[TD="bgcolor: #DBEEF3, align: right"]3598[/TD]
[TD="bgcolor: #FFFF00, align: right"]1034001[/TD]
[TD="bgcolor: #FFFF00, align: right"]1034814[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]
[TD="align: right"]6058[/TD]
[TD="align: right"]19[/TD]

[TD="align: right"]154730[/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1034815[/TD]
[TD="align: right"]1034816[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Result​



Thank you,


Bob
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
split range into multiple range based on blank row for each range
Replies
4
Views
508
Ali M
A
N
  • Question Question
How to update data that is on two worksheets but different formats
2
Replies
14
Views
801
OaklandJim
O
J
  • Solved
Count Row Skipping Duplicates in Date Range
Replies
6
Views
991
SanjayGMusafir
SanjayGMusafir
R
  • Locked
  • Question Question
Need help creating a macro splitting up number ranges
Replies
1
Views
617
Joe4
Joe4
R
  • Locked
  • Question Question
Need help creating a macro working with a range of numbers
Replies
1
Views
287
Joe4
Joe4

Forum statistics

Threads
1,223,275
Messages
6,171,121
Members
452,381
Latest member
Nova88

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