Auto-update row numbers

[pban92]

I have a two columns spreadsheet listing 1000+ items subjected to multiple revisions. The first column (A) contains ID showing the numbering and the second column (B) contains the item description.

In the case when a certain item is to be removed, instead of deleting the entire row, I would like to delete the corresponding number. However, this requires manual numbering of the entire list.

Is there a way to auto-update the numbering in case any number is deleted? Also, in the case where a new item (hence a new row) is inserted, the numbering should be auto-updated.

Thanks for any suggestion.

 

[liveinhope]

can you ,post a few rows of sample data and include a "before" and "after" example of renumbering

 

[pban92]

Thanks for the response. Here is the data file example http://www.filedropper.com/excelnumberingtest

 

[pban92]

File after editing the list http://www.filedropper.com/excelnumberingtestbefore Notice the number is not updated