Aaah, that's a great idea Arvil. (Yes, of course, a requirement number once assigned should never change.)

For this particular project, we're pasting in finalized text from a Word document to create a numbered Requirements Traceability Matrix. The formula is just a quick and easy method for populating numbers to thousands of lines. Once numbered, we'll copy/paste-special/values and be done. If we add any requirements later then it will only be a handful. Those we can handle manually.

However, your solution will work very well for other projects. On many we commonly add requirements after the fact. I love your solution. It's definitely going in my arsenal of solutions - and it will be used.

Thank you very much,
Andrew