Hello all,

I would like to know how to:
  1. insert a row in between two rows that meet the following condition (example with rows 2 and 3): A2 < A3 - 1
  2. when the row is added (let's name it row number K), I want to fill the cell AK with the following: value of AK = value of A(K-1) + 1
  3. repeat this until for any row (number N) except the last one, I have the following: value of AN = Value of A(N+1) - 1


Example:

If my current sheet shows the following:

A1 = 8
A2 = 9
A3 = 15
A4 = 17
A5 = 18


I would like to get to this:

A1 = 8
A2 = 9
A3 = 10
A4 = 11
A5 = 12
A6 = 13
A7 = 14
A8 = 15
A9 = 16
A10 = 17
A11 = 18


(The cells in bold belong to the newly created rows)


Thank you