Hi Dear All,
I have an excel sheet that is feeded by an Access table, so the number of the rows is variable.
I am looking for a code that calculate IDs based on the first ID (123 in this example).
So, the idea is to replace 1000 with (123 + 1) and 2000 with (123 + 1 +1) .. to the last column that is not empty.
The first ID is always in A2 Range.
<tbody>
</tbody>
Thank you in advance
I have an excel sheet that is feeded by an Access table, so the number of the rows is variable.
I am looking for a code that calculate IDs based on the first ID (123 in this example).
So, the idea is to replace 1000 with (123 + 1) and 2000 with (123 + 1 +1) .. to the last column that is not empty.
The first ID is always in A2 Range.
ID | Name |
123 | TEST1 |
1000 | TEST2 |
2000 | TEST3 |
3000 | TEST4 |
4000 | TEST5 |
<tbody>
</tbody>
Thank you in advance