excel question

Soldato
Joined
28 Sep 2003
Posts
10,414
Location
London
say i have a list of invoices in excel

and i want to add a new one to the list, i have to scroll all the way down to the bottom of the list, to find the next empty row to add my new invoice details

is there a way , that excel can add to the list at the top, instead of putting it on the bottom

so the list would show as newest at the top all the time ?
 
thanks..

i thought of adding a new road each time, but there are a few equations on the grid and wehn you add a new row, it doesnt take the equation with it

unless i can work out a way to do that.....
 
Google that if you want. I could send you the spreadsheet if you want to play with it and see how the macro works and then check out the code and see if it does what you want. Should find my Gmail in trust or something so add me to MSN if you want. Am online now. :)

thank you, im not home at the moment , but i will add you when im back

Or, just get to the bottom of the list very quickly by holding down ctrl and pressing the down arrow.

thank you, will have a try of that too
 
Back
Top Bottom