thanks a lot for your prompt reply.
but thing is that i need to keep on copying data from my online account. hence sorting will not be the solution. I am givivng an example :
data in online a/c
trans date trans id cheque no. debit credit balance
28/5/12...
if i download my bank statement , it gives data in descending order. so how can i insert rows with formulae from rows down.
can this be done using vba program