Hey all, thanks for viewing this and hopefully giving me some help...I am writing a list of counts that I then need to expand to be then utilized in an ACCESS database to design tags for our mailing. Here is an example of the list and then what I need it to look like:
[U]ZIP ROUTE COUNT BOOK
85716 C004 551 8A
85716 C006 765 8A
I need to then expand this list to show a separate line for each bundle of 50 with the last bundle displaying the odd count. So an example of the first line of data expanded would be:
85716 C004 551 8A 11 11 51
85716 C004 551 8A 10 11 50
85716 C004 551 8A 9 11 50
And so on, so that when I pull the Excel spreadsheet into Access it will throw each column of data into their respective title slots and print tags that show:
ZIP Book
Route
50 of COUNT PKG # of #
Does that make sense?
Hope someone can help
Bookmarks