How to insert random lines

[MADGE25]

Hello to all. I am looking for a way to insert 3 lines automatically whenever the column "Group" consist of the group name that is different from the previous line. Group names have letters, numbers and some special characters. I have Microsoft Office 2007 installed on my computer. Can anyone of you help me to get this?

[opaper]

You mean when you take another name for online group three interrelated or you want to scan the file (sorted by group) and each change in value of the cell group to get three lines?

[MADGE25]

The file currently contains 550 lines without spaces. The group "ABC" is in column E on lines 4,5 and 6. The group "DEF" is currently on lines 7 and 8 ... . I try to make 3 lines added what is currently on line 7 and following 3 lines below. Then the same thing after the group "DEF" to be made to lines 10 and 11 following the addition of 3 lines of the first group. There are currently 82 different groups in column E. So there will be 82 X 3 lines to add.

[CitricAcid]

It can be done by macro. Basically, for each row (other than the first if you start at line 1), if you look inside the line = content of the previous line and that inside the <> "" (if not at the end of your three vacuum line, you're going to put 3 others), whether you spend the next, if you insert 3 lines

[opaper]

Sub insertline ()
 Dim a,t
 t = Range ( "a65535"). End (xlUp). Row 
 For a = 2 To t
 If Cells (a, 1). Value <> Cells (a - 1, 1). Value Then 
 Range (Cells (a, 1), Cells (a + 2, 1)). EntireRow. Insert 
 t = t + 3 
 a = a + 3 
 End If
 Next
 End Sub