Please Help! I hope the formatting below is readable. I am trying to create a
spreadsheet to import into quickbooks. I have the following table created in
excel, but I am trying to set up automatic formating to quickbooks.

My original data looks like this:

ShipDate BOL PartNumber Quantity Price Amount
5-7-08 9497 Front 4680 9.85 46099.59
5-7-08 9497 Rear 450 8.98 4039.41
5-7-08 9497 Cap 1800 2.40 4314.29
5-9-08 9494 Front 2880 9.85 28368.98
5-9-08 9494 Rear 450 8.98 4039.41

The following format breaks the excel spreadsheet into individual
transactions by BOL. The only calculation needed is the amount on the !TRNS
line. This adds up all the amounts for each BOL as a total. Any information
that is in the example below but is not taken from the data above will be a
constant on all transactions.

!TRNS TYPE DATE ACCNT NAME AMOUNT DOCNUM TOPRINT TAXABLE ADDR1
!SPL TYPE DATE ACCNT NAME AMOUNT DOCNUM QNTY PRICE INVITEM
!ENDTRNS
TRNS INVOICE 5/9/2008 AR ABC 32408.39 9494
SPL INVOICE 5/9/2008 Sales -28368.98 9494 2880 9.85 Front
SPL INVOICE 5/9/2008 Sales -4039.41 9494 450 8.98 Rear
ENDTRNS
TRNS INVOICE 5/7/2008 AR ABC 54453.29 9497
SPL INVOICE 5/7/2008 Sales -46099.59 9497 4680 9.85 Front
SPL INVOICE 5/7/2008 Sales -4039.41 9497 450 8.98 Rear
SPL INVOICE 5/7/2008 Sales -4314.29 9497 1800 2.40 Cap
ENDTRNS