shan
12-09-2015, 11:41 PM
Hello Everybody,
Request your help for a macro which will insert a row if defined value is not available.
I have a file in which row A1, A2, A3, A4, A5 has defined values. Basis this I have written a macro. But the problem if A1 value is not available then automatically A2 value become as A1 , A3 as A2 and so on...
So I need a macro which will check for the sequence and if not found it will insert a row in between...
e.g.
Row no. A1 - FC
Row no. A2 - F
Row no. A3 - A
Row no. A4 - AR
Row no. A5 - R
If FC is not available then F will come on the place of FC and so on
Row no. A1 - F
Row no. A2 - A
Row no. A3 - AR
Row no. A4 - R
So required a macro which will check the Sequence of FC, F, A, AR, R and if something is missing then it will insert blank row in the place of that Value
In the above example macro should insert a row above F. So the output will be ...
Row no. A1 - Blank Row
Row no. A2 - F
Row no. A3 - A
Row no. A4 - AR
Row no. A5 - R
Hope I am able to explain this
Thank you in advance
Rgds,
Shan
Request your help for a macro which will insert a row if defined value is not available.
I have a file in which row A1, A2, A3, A4, A5 has defined values. Basis this I have written a macro. But the problem if A1 value is not available then automatically A2 value become as A1 , A3 as A2 and so on...
So I need a macro which will check for the sequence and if not found it will insert a row in between...
e.g.
Row no. A1 - FC
Row no. A2 - F
Row no. A3 - A
Row no. A4 - AR
Row no. A5 - R
If FC is not available then F will come on the place of FC and so on
Row no. A1 - F
Row no. A2 - A
Row no. A3 - AR
Row no. A4 - R
So required a macro which will check the Sequence of FC, F, A, AR, R and if something is missing then it will insert blank row in the place of that Value
In the above example macro should insert a row above F. So the output will be ...
Row no. A1 - Blank Row
Row no. A2 - F
Row no. A3 - A
Row no. A4 - AR
Row no. A5 - R
Hope I am able to explain this
Thank you in advance
Rgds,
Shan