Akash030193
New Member
- Joined
- Apr 28, 2019
- Messages
- 22
Hello! I need your help in below query.
I am looking for a VBA program that help me to add next sequence number in next blanks row cell only (one cell only). For example, 5th row is blank cell, i need to place next sequence number as "3". Similarly in the same column, refer row 9, i need to place next sequence number as "3"... similarly for all subsequent series..
1) Question
<tbody>
</tbody>
After applying macro
<tbody>
</tbody>
2) Second Example
Question
<tbody>
</tbody>
After applying macro
<tbody>
</tbody>
Code to be run if there is any next blank row in the column "A", and to be run for one next cell only.
https://1drv.ms/x/s!AgoBOBbQ2MyJgQcKF83--PVdg_3j
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">A1Revision2031425
6071829
10011112213
14015116217
I am looking for a VBA program that help me to add next sequence number in next blanks row cell only (one cell only). For example, 5th row is blank cell, i need to place next sequence number as "3". Similarly in the same column, refer row 9, i need to place next sequence number as "3"... similarly for all subsequent series..
1) Question
A | |
1 | Revision |
2 | 0 |
3 | 1 |
4 | 2 |
5 | |
6 | 0 |
7 | 1 |
8 | 2 |
9 | |
10 | 0 |
11 | 1 |
12 | 2 |
13 | |
14 | 0 |
15 | 1 |
16 | 2 |
17 |
<tbody>
</tbody>
After applying macro
A | |
1 | Revision |
2 | 0 |
3 | 1 |
4 | 2 |
5 | 3 |
6 | 0 |
7 | 1 |
8 | 2 |
9 | 3 |
10 | 0 |
11 | 1 |
12 | 2 |
13 | 3 |
14 | 0 |
15 | 1 |
16 | 2 |
17 | 3 |
<tbody>
</tbody>
2) Second Example
Question
A | |
1 | 0 |
2 | 0 |
3 | 0 |
4 | |
5 | 0 |
6 | 0 |
7 |
<tbody>
</tbody>
After applying macro
A | |
1 | 0 |
2 | 0 |
3 | 0 |
4 | 1 |
5 | 0 |
6 | 0 |
7 | 1 |
<tbody>
</tbody>
Code to be run if there is any next blank row in the column "A", and to be run for one next cell only.
https://1drv.ms/x/s!AgoBOBbQ2MyJgQcKF83--PVdg_3j
****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">A1Revision2031425
6071829
10011112213
14015116217