I would like to have auto-numbering after inserting new row, required that the new row has input any text.
here is the example:
Item no. name
1 Mary
2 Tom
3 Jack
4 Peter
5 John
When I insert new row, I would like to have the row no. only when the column "name" has some text inside, otherwise the auto-numbering will skip the blank row.
Item no. name
1 Mary
2 Tom
3 Jack
4 Peter
5 John
Item no. name
1 Mary
2 Tom
3 Susan
4 Jack
5 Peter
6 John
Would there be any code to do this?
Thank you very much!
here is the example:
Item no. name
1 Mary
2 Tom
3 Jack
4 Peter
5 John
When I insert new row, I would like to have the row no. only when the column "name" has some text inside, otherwise the auto-numbering will skip the blank row.
Item no. name
1 Mary
2 Tom
3 Jack
4 Peter
5 John
Item no. name
1 Mary
2 Tom
3 Susan
4 Jack
5 Peter
6 John
Would there be any code to do this?
Thank you very much!