VBA to Copy data and format transactions for QuickBooks import

[jtbsu]

I am currently trying to take an excel file that has purchase transactions as shown below and convert them into something that will import into an accounting software. I know it would be easier for that person gathering the information to input it the information directly into the accounting software but unfortunately for control purposes I was told that is not allowed. So I have to duplicate the work already being done and I would like to have the work from the person gathering the information to just import into the accounting software. Any help is greatly appreciated. I have been trying to search and build such a macro with absolutely no luck. Thank you.

Date Check # Vendor Notes Account Number Amount Total Pmt Location Trans # 12/1/13 1000 Staples Supplies 6120 100.00 100.00 North 1 12/1/13 EFT Office Max Supplies 6120 200.00 240.00 South 2 ******* Supplies 6125 40.00 General 2 12/1/13 EFT Post office postage 7250 150.00 150.00 General 3 <tbody> </tbody>

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

After the conversion the information must look like this with 1111 being the checking account that was used to pay for the item(s). So 1 purchase from office max may have to be split between 2 expense accounts with the sum hitting the bank.

	Blank	Transaction Type	Date	Account Number	Name	Amount	Location	Check #	Notes
TRNS		Check	12/1/13	1111	Staples	-100.00		1000
SPL		Check	12/1/13	6120	Staples	100.00	North	1000	Supplies
ENDTRNS
TRNS		Check	12/1/13	1111	Office Max	-240.00		EFT
SPL		Check	12/1/13	6120		200.00	South	EFT	Supplies
SPL		Check	12/1/13	6125		40.00	General	EFT	******* Supplies
ENDTRNS
TRNS		Check	12/1/13	1111	Post Office	-150.00		EFT
SPL		Check	12/1/13	7250		150.00	General	EFT	Postage
ENDTRNS

<tbody>
</tbody>