excel question

[Paul11]

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 ?

 

[MarcLister]

How are you adding the data? Manually? If so just insert a new row at the top of the list. Pushes everything down one row.

There is a macro I think you could use for this kind of stuff. I played with it for a project 4-5 years ago. I'll look for the spreadsheet and see if it'll work for this.

 

[Paul11]

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.....

 

[gillywibble]

sort data?

Even if you add lines, it should keep the formulas.

 

[MarcLister]

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.....

I'm thinking a macro to find the last row, let you add your data then sort it?

 

[Paul11]

sort data?

Even if you add lines, it should keep the formulas.

dont want to have to sort data each time i add a new line

I'm thinking a macro to find the last row, let you add your data then sort it?

i didnt want anyone to go to any hassle with this, i just didnt know if there was an easy answer that i was missing. .

 

[MarcLister]

dont want to have to sort data each time i add a new line

Get a macro to add a new row, let you insert data then sort data.

i didnt want anyone to go to any hassle with this, i just didnt know if there was an easy answer that i was missing. .

Probably not an easy answer.

Btw just found the old spreadsheet. I used the following to go onto the next available row and paste data:

Selection.End(xlDown).Select
    ActiveCell.Offset(1, 0).Range("A1").Select

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.

 

[Participant]

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

 

[Jed Shields]

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

Was just about to say that ...

 

[Paul11]

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