If false then go to next cell

[raghurama]

Hi All,

I have a data like below but it not standered keep changing (with live data dont where Flase row will come). If it is Flase then should leave one row as balnk or empty and start from next row. I would like to have if statement. Please could you guys help me out.


20
19
18
17
16
15
14
13
12
11
10
FALSE
8
7
FALSE
5
4
3
FALSE
1


out put like

20
19
18
17
16
15
14
13
12
11
10
-- Blank
FALSE
8
7
-- Blank
FALSE
5
4
3
-- Blank
FALSE
1

Thank you,
Rama.

[Special-K]

Post your workbook, it's diffcult to understand your problem.

[jraj1106]

Hello...

You can try this macro:

Sub addrow()
Dim i As Integer

i = 1
While Range("A" & i).Value <> ""
If Range("A" & i).Value = "False" Then
Rows(i & ":" & i).Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
i = i + 1
End If
i = i + 1
Wend
End Sub

Please note: I have assumed that the data provided by you is in column A.

Regards...