I forgot to include the Part No col in my structure example:

B:B; Qty
C:E; Part No
F:H; Description (in various configurations)
I:I; Unit Price
J:J; Amount

This was later revised as follows:

B:B; Qty
C:E; Part No
F:J; Description1
F:G; Description1S, H:J; Description2
F:H; Description1L, I:J; Description2
K:K; Unit Price
L:L; Amount
M:M; formula to set print flag
B?:L?; Print_Area

All templates were built using a master template that contained all the
business logic, needing only the line items to be inserted as required.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc