I have a spreadsheet that has the following information in column A. A simple calculation that I use as a line id.
A1 = 1
A2 = A1+1
A3 = A2+1
A4 = A3+1
A5 = A4+1
The problem is that this file is updated frequently and sometimes rows need to be removed. Is there any way through a formula (or VBA if not) that I can stop this from happening?
A1 = 1
A2 = A1+1
A3 = A2+1
A4 = A3+1
A5 = A4+1
The problem is that this file is updated frequently and sometimes rows need to be removed. Is there any way through a formula (or VBA if not) that I can stop this from happening?