How to add ascending numbers after finding last row of data in adjacent column

[Emmaly]

Hello again!!

Does anyone know how to do the following?

I want to find the last row in the data field in the adjacent column to my left, then put in ascending/descending (depending on which way you look at it!) in from the bottom up to the top so row 1 would be 1, then 2 would be 2 etc etc

Or if not i can put in something at the bottom of the rows in that column by doing and offset then maybe you could tell me how to put the numbers in.

thank you.

I'm nearly done, hopefully there wont be many more questions!

Oh and when doing this can someone tell me is there a way to to simply move from my active cell to the column next to me, so i can find the last data cell in a column then jump over to the next column which would be empty then put something in it and copy up.

[JBeaucaire]

If the numeric sequence starts in row 1, you can put this formula in a column and copy down to get sequential numbers:

=ROW()

If the numeric sequence needs to start row5 but start count at 1, put this in row5 as the first formula, then copy down:

=ROW(A1)

You can use VBA to enter that formula. Let's say you have a random number of rows of data and you want to put numbers in column A, there is existing data in B:E. Look UP column B to spot the last row and store that number in a variable.

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.

Another way using OFFSET to answer your final question:

Please Login or Register  to view this content.