Actually, one invoice group begins with the letters G-S. The other group
begins with the letters A-F and T-W. (There are no invoices for X, Y & Z).
golddave wrote:
Maximum number per customer is probably 10. Also, I just got a requirement
that there may be 2 classifications of invoices. So there will be a column E
that lists some of them. I'll have to figure out how to parse them based on
cell ranges (I think).
What is the maximum number of multiple-orders that you are likely to
encounter? Your example shows 2 for Pujols and Wright.
[quoted text clipped - 6 lines]
--
Message posted viahttp://www.officekb.com
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200909/1