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