macro to insert a cell and shift down depending on the value in another cell containing a string

[CarDyer]

Hi
Hope somebody can help. I've been trawling forums looking for a solution without success.
I am new to VBA, so would be grateful if a full macro could be provided that I can lift and paste.

I am trying to achieve the following

I have a column A with values. Some of the cells contain the string 'timeslice' and other data.
When there is an occurrence of this, I want to insert a blank cell in columns B and C on the same row.
Example
from this:-
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]timeslice 01/01/98 aaa[/TD]
[TD]apple[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]orange[/TD]
[TD]apple[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]timeslice 12/03/89 bbb[/TD]
[TD]grape[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]banana[/TD]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD]grape[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]timeslice 19/09/01 jjj[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="width: 265"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]to this:-[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]timeslice 01/01/98 aaa[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]apple[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]orange[/TD]
[TD]orange[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD]timeslice 12/03/89 bbb[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]apple[/TD]
[TD]green[/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD]grape[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD]banana[/TD]
[TD]banana[/TD]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]timeslice 19/09/01 jjj[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]grape[/TD]
[TD]grape[/TD]
[TD]black[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 265"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

Mnay thanks in anticipation.

 

[JoeMo]

This assumes your data begin in cell A1.

Sub InsertCellsBC()
'assumes data start in A1
Dim V As Variant, i As Long
V = Range("A1:A" & Cells(Rows.Count, "A").End(xlUp).Row).Value
Application.ScreenUpdating = False
For i = LBound(V, 1) To UBound(V, 1)
    If V(i, 1) Like "timeslice*" Then
        Cells(i, "B").Resize(, 2).Insert shift:=xlDown
    End If
Next i
Application.ScreenUpdating = True
End Sub

 

[My Aswer Is This]

Try this:

Sub Time_Slice()
Application.ScreenUpdating = False
Dim i As Long
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
    For i = 1 To Lastrow
        If InStr(Cells(i, 1).Value, "timeslice") Then
        Cells(i, 1).Resize(, 2).Offset(0, 1).Insert xlShiftDown
        End If
    Next
Application.ScreenUpdating = True
End Sub

 

[CarDyer]

Hi JoeMo
Very grateful for the quick response. It works perfectly. I can now use it in work tomorrow.
My Aswer is this sent me similar and it too worked. Glad I took the time to post the question.

 

[CarDyer]

Hi My Aswer is this
Very grateful for the quick response. It works perfectly. I can now use it in work tomorrow.
JoeMo sent me similar and it too worked. Glad I took the time to post the question.

 

[My Aswer Is This]

Glad I was able to help you. Come back here to Mr. Excel next time you need additional assistance.

Hi My Aswer is this
Very grateful for the quick response. It works perfectly. I can now use it in work tomorrow.
JoeMo sent me similar and it too worked. Glad I took the time to post the question.

 

[CarDyer]

Thank you. Will do.