Hi,
I think this is the vector
try to make it

[VBA]Sub convertxt()
'select preformatted *txt and insert into sheet raw
'you can record it like macrorecorder and correct it manually
End Sub
Sub analize()
'define REPORT DATE
'find last rawsheet row (lastrow)
'find where we will write row(actwriterow)
'cycle start from actrow=2 to lastrow
'if found "PAID & WAIT TOTAL" then check the next cell
'if biggest than 0 then
'select the cells(actrow-2,PAYMT_date_col)
'check date diff
'if needed, then read more details like before select
'write datas like
'sheets("Paid & Wait").cells(actwriterow,1)=fnd
'sheets("Paid & Wait").cells(actwriterow,2)=typ
'sheets("Paid & Wait").cells(actwriterow,3)=paydate
'...etc
'increase actwriterow
'actwriterow = actwriterow + 1
'end if
'cycle End from actrow (2 to lastrow)
'msgbox "analize done"
End Sub[/VBA]

if you need more help, yust write