nugol
02-18-2016, 05:25 AM
Hy guys,
I got a little problem and would appreciate some help :)
In my list, I want to find all rows where the current letter (status) is x and write a 1 right beside it.
The whole thing should start from Column F and go left through the neighbouring cells. In my example below, there would be a 1 in Column F Row 1 and Row 4.
In short, the macro should go left from Column F and should find out if the current status is x or xx and make it 1 in Column F. Else it should just write a 0.
Here now my litte example:
A
B
C
D
E
F
Row1
r
r
r
r
x
1
Row2
r
r
xx
x
r
Row3
r
r
Row4
r
r
x
1
Row5 r x xx 1
Thanks in advance guys. :)
I got a little problem and would appreciate some help :)
In my list, I want to find all rows where the current letter (status) is x and write a 1 right beside it.
The whole thing should start from Column F and go left through the neighbouring cells. In my example below, there would be a 1 in Column F Row 1 and Row 4.
In short, the macro should go left from Column F and should find out if the current status is x or xx and make it 1 in Column F. Else it should just write a 0.
Here now my litte example:
A
B
C
D
E
F
Row1
r
r
r
r
x
1
Row2
r
r
xx
x
r
Row3
r
r
Row4
r
r
x
1
Row5 r x xx 1
Thanks in advance guys. :)