Dynamic Sequential Number Assignment

There is an Excel file that teaches how to perform the Dynamic Sequential Number Assignment operation.

Excel Source: Dynamic Sequential Number Assignment

Sequential numbers are dynamically updated based on the presence of rows in this file. Additionally, automatic adaptation of sequence numbers to deleted and added rows is ensured through the macro. Thus, correct numbering is guaranteed continuously in lists. For this reason, the need for manual correction in growing or changing lists is eliminated. Therefore, combined usage of ROWS and INDIRECT functions is reinforced through this example.

Hope it is useful.