Hi All,

I have a list that I need to subtotal and then insert a blank row after each subtotal. How can this be achieve with a macro?

SPID Acct # Authorized Amount Current Total
RTF 10 $1000.00 $109 $500.00
RTF 15 $500.00 $0 $500
RTF Total $1500 $109 $1000
FDG 270 $25000 $21000 $21000
FDG Total $25000 $21000 $21000

I need to add a space between RTF Total and FGD. My original list (no subtotal) contains about 2500 records. After subtotaling based on SPID, I have about 1000 records. So I need to insert 1000 blank rows to the file. Any suggestions?