Excel auto numbering

In column 1 ensure you stick in the following formula

=ROW(A2)

That will pretty much do what you want. Krompton is right, Access or any other database is better for this though.

I have my asset details on a excel sheet.What i want is when i insert a row in the file it has to automatically change the serial no's which are there.

Are the serial numbers the numbers from the asset like the system number assigned to a computer by the factory or do you "create" a random asset number? Are these assets from differing manufacturers? If you have something like a listing of all IT assets over x dollar amount and you are using the manufacturers serial number, although unlikely, it is possible that two numbers could be the same, preventing you from mataining Uinque numbers.

Basically you have a database. Truthfully I would put the minimal effort into setting up an Access table and import the information instead of making an Excel spread sheet work like one. Though if that's REALLY what you want let us know I'm sure we can put something together for you.

Can you list three or four rows of the information you keep (mask any sensitive info) and what you want it to do.

You posted ..."when i insert a row in the file it has to automatically change the serial no's which are there" what information is already there that needs to be changed? I would expect a new row to be blank.

Krompton

Hi,

thanks for the interset shown.

I have put in the details that i maintain.

1      C150      Arundhathy Manmidi      Dev-hyd-pc427      R02616            Intel/IBM
2      C151      Sathyanaraynan Murthy      Dev-hyd-pc454      R02606            Intel/IBM
3      C152      Bharath Dhraviam      Dev-chen-pc399      R5196      IBM      8771
4      C153      S Mohamed Bakkrudeen       Dev-chen-pc008      R4970      IBM      8123
5      C154      Amardeep  Ashok      Dev-chen-pc1565      R3107      Intel      GIGA
6      C155      Peter Jose      Dev-chen-pc1096      R2923      IBM      8175

Please copy these details to a excel file.

I am taking about the first colom the serial no colum.That has to change automatically when i delete a row or insert a row.

Regards
Sharath

Any help...........

In your original post you stated ..."It must be able to stay unique if a row is inserted and must not change if a row is cut/pasted." (see B below) but in your last post you said ..."That has to change automatically when i delete a row or insert a row." (see A below)

I'm confused here?!?
Are the Cxxx numbers actual Serial Numbers or are they just self assigned Sequence Numbers?

From your post:
1      C150      Arundhathy Manmidi      Dev-hyd-pc427      R02616            Intel/IBM
2      C151      Sathyanaraynan Murthy      Dev-hyd-pc454      R02606            Intel/IBM
3      C152      Bharath Dhraviam      Dev-chen-pc399      R5196      IBM      8771
4      C153      S Mohamed Bakkrudeen       Dev-chen-pc008      R4970      IBM      8123
5      C154      Amardeep  Ashok      Dev-chen-pc1565      R3107      Intel      GIGA
6      C155      Peter Jose      Dev-chen-pc1096      R2923      IBM      8175

If you were to delete ROW 4 which of the following is what you want left?
A) Cxxx numbers are redone
1      C150      Arundhathy Manmidi      Dev-hyd-pc427      R02616            Intel/IBM
2      C151      Sathyanaraynan Murthy      Dev-hyd-pc454      R02606            Intel/IBM
3      C152      Bharath Dhraviam      Dev-chen-pc399      R5196      IBM      8771
4      C153      Amardeep  Ashok      Dev-chen-pc1565      R3107      Intel      GIGA
5      C154      Peter Jose      Dev-chen-pc1096      R2923      IBM      8175
OR B) Cxxx numbers are left unchanged except for the deleted row's number being deleted as well
1      C150      Arundhathy Manmidi      Dev-hyd-pc427      R02616            Intel/IBM
2      C151      Sathyanaraynan Murthy      Dev-hyd-pc454      R02606            Intel/IBM
3      C152      Bharath Dhraviam      Dev-chen-pc399      R5196      IBM      8771
4      C154      Amardeep  Ashok      Dev-chen-pc1565      R3107      Intel      GIGA
5      C155      Peter Jose      Dev-chen-pc1096      R2923      IBM      8175

B is what I would think you would want but I don't know. If B IS what you want would the number C153 be reused?

Krompton

Hi,

Sory for the delay in answering.

I need to change the Serial no's that is
1
2
3
4
5
Not the C*** no

These are the nos for the rows.

It has to change automatically if i delete a row.

regards
Sharath