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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Auto numbering a column in Excel
- Thread starter banglong
- Start date
- Joined
- Feb 28, 2002
- Messages
- 2,541
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.
Upvote
0
Excel Facts
Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
