I'm trying to convert a downloaded csv file to an iif for Quickbooks. I need a macro that will copy the entire row of a transaction, invert the amount, and insert the copied row right below. Then, insert a blank row to separate each transaction.

I'd be going from this:


Posted Date Payee Account Amount
1/10/2013 X CC Acct -16.11
1/10/2013 Y CC Acct -35
1/10/2013 Z CC Acct -1


to this:

Posted Date Payee Account Amount
1/10/2013 X CC Acct -16.11
1/10/2013 X Exp Acct 16.11

1/10/2013 Y CC Acct -35
1/10/2013 Y Exp Acct 35

1/10/2013 Z CC Acct -1
1/10/2013 Z Exp Acct 1

I can manually change the expense account once formatted.

I'm very new to VBA so any help would be greatly appreciated.

Many thanks,

Raquel