I need to split up records that have greater than 2000 in the control number range column (hyphenated number range). I have over 75,000 records to manipulate so any help would be appreciated.
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.).
Thank you,
Bob
Bookmarks