When this Macro is run, it inserts a new line above any cell that has value equal to "hello-there" in the first column
Dim i As Long
i = 2
'loop until a space is found in the first(1) column
Do Until Trim(Cells(i, 1)) = ""
'change the content to be matched
If Cells(i, 1) = "hello-here" Then
'row is inserted where match is found so
'we need to jump one step down, otherwise we will keep looping..
'we don't want to keep looping, right buddy?
i = i + 2
i = i + 1