Inserting rows with formula from rows down

[paramnayak]

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

 

[Hui]

Paramnayak


Firstly, Welcome to the Chandoo.org forums.


Select all your data, You can sort Ascending goto the Data Sort Tab


You can insert rows for Formulas, Select the Row below where you want the New Row

Right Click on the Row Number and Select Insert or press Alt+I then R

 

[paramnayak]

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 5000 35000

27/5/12 10000 30000


now i will copy this data and insert in my excel file . since data keeps on getting updated, sorting is not the solution (because i have to match the balance with banks figure )

 

[Hui]

Why not put all your calculations in he first 5-10 rows

Have your data below that

Use named formula to automatically pickup the new data

 

[paramnayak]

but if extra rows are deleted there is problem