I enjoy a datasheet beside no row breaks. I'd resembling to attach a blank row between one and the same datapoint every time, but near are thousands of flash items, and I enjoy to tag on a row every 7th row and doing it manually. Is that possible?
For instance, let's speak I own a column of info beside background:
Jim
Jack
John
Eric
Dan
Dave
Jeff
and after it repeats minus a row break... to look resembling this:
Jim
Jack
John
Eric
Dan
Dave
Jeff
Jim
Jack
John
Eric
Dan
Dave
Jeff
And so on and so forth...
What I'd approaching to do is put a space contained by between the columns (all the course across the row), to brand it look approaching this instead:
Jim
Jack
John
Eric
Dan
Dave
Jeff
Jim
Jack
John
Eric
Dan
Dave
Jeff
Is that possible? Can you provide me next to the formula or a path to do that?
Answers: If your register of 7 name repeats 1000 times and is surrounded by A1:A7000, you can set B1:B8000 to this:
=IF( INT((ROW(A1)-1)/8) = INT(ROW(A1)/8), INDEX( A$1:A$200, ROW(A1) - INT((ROW(A1)-1)/8) ), "" )
Or you can put those formulas contained by another worksheet in like peas in a pod workbook so race don't enjoy to see the unbroken register.
The single entity I can suggest of is to lay emphasis on adjectives the rows where on earth you want a row inserted. Tedious, but smaller number so than inserting one row at a time.
Or you could insert a row in between the first two sets of notes and next copy that a bunch of times below it.
Here is a rapid macro that will insert your rows.
Range("A1").Select
ActiveCell.Offset(7, 0).Range("A1").Select
Selection.EntireRow.Insert
For i = 1 To 5
ActiveCell.Offset(8, 0).Range("A1").Select
Selection.EntireRow.Insert
Next i
Where I show the file 1 to 5 you can evolution the 5 to a number that equals your sets of seven. If you don't know how to start a macro email me and I'll explain.