Vbscript Sorting Follow
Hello everyone taking the time to read this.
I am trying to sort at print time in BarTender, or even before print time in Excel, using VB scripting.
Previously, I have made my sheet of records by turning the spreadsheet 90 degrees counter clockwise, taking the second half of the records and inserting them into a second sideways column (row) in reverse order.
I am quite sure that sounds totally confusing. This is done so that when I print the sorted spreadsheet as a PDF, it prints on the card stock with record 1 in the top right corner, proceeding left to record 2, 3 and 4. And then on the bottom half of the sheet are the records starting at the halfway point +1, then +2, etc.
Now I am not printing a PDF but using BarTender to pluck the records straight from the Excel file, one at a time, at print time. So I need the records sorted so that record 1-4 will come out first, then (total records/2)+1, +2, +3,+4, then record 5-8, then (total records/2)+5, +6, +7, +8 (this example would be the first two pages) and so on until the end of the records.
I have no issue with getting BarTender to print from an Excel file as the database setup is easy in BarTender. I just cant get the sort order correct.
Anyone have any insight?
Please sign in to leave a comment.