Auto numbering a column in Excel

[banglong]

Hi, Need your help on how to make autonumbering in column on each new data inserted. The new data inserted can be above, middle and below the column, and each data has sequence numbering. The numbering for old data cannot be change when each time new data inserted. Please refer attachment below. Need your help either in formula or macro. Thanks in advanve.

 

[smozgur]

good job bro...thanks so much..im appreciate it so much...

I switched the marked solution post as confirmed. For your future questions, please mark the post that answered the question instead of your feedback post to help future readers. Thanks.