auto number

[Eddie]

I was wondering how to go about setting up a work sheet to so as soon as I
click in the first row that I will be adding data it would automaticly mark
that row Number 1 and when I enter new data in the second row it
automatically puts in 2, and so on? Thanks

 

[JCS]

Hi Eddie - Try this: (Excel 2003)

You don;'t give much info about how your spreadsheet is set up so try this:

Let's assume you have all of your field names in the first row and the A col
will hold the auto number.

1. In a2 type: =cell("row",a2)
2. Select Data from the menu
3. Select Form from the drop down menu. A form will display. Start typing
in your data.

In order for this to work at all times you must place your cell pointer
anywhere in your list of data and then follw steps 2 and 3.

Id this helps, please press Yes

John

 

[Eddie]

I did what you said but the result was 1 number in that one cell. What I
would like to do and may not have been too clear the entire first column is
for a sequencial number going down each column has data in it after that but
the first column is for the number like
1.
2.
3.
4.
5.
6.
and so on and the cell info would not change it is just a numbered spot for
that data in the row. Example

# NAME DATE TIME PLACE

1. xxxxxxx xxxxxxx xx:xx xxxxxx
2. xxxxxxx xxxxxxx xx:xx xxxxxx
3.
Just like that nothing fancy just a sequencial number

 

[Frank]

Hi Eddie,

Try this formula instead...
=N(OFFSET(A2,-1,0))+1 (where A2 is the cell's own address)

Note that this formula will not be 'automatically' added to each row. You'd
need a macro to do that. You'll have to copy this formula down the column.
However you can get a similar effect by using
=IF(B2<>"",N(OFFSET(A2,-1,0))+1,"") and copying it down column A. If the cell
in column B is blank, nothing will show. If the cell in column B is not
blank, the next sequence number will display.

If you want the next sequence # to display AFTER the last row of data, use
B1 in the second formula instead of B2.

Hope this helps.

Francis Hayes

I have lots more tips available at...
www.TheExcelAddict.com

 

[Eddie]

Hey Guys that was right on that is what I was trying to do, it has been so
long since I had been away from the program I did not realize that I had to
pull the handle down to the cell that I needed in order to fulfill the
compleation of the function. thanks again I also signed up for your
newsletter. Thanks again, Eddie