Make excel fill in consecutive order in non consecutive cells

Hi everyone,
I'm trying to create a table that repeats itself but the first row is changing based on a reference to another cell.
The problem is that there are other rows in between those first rows, so using the fill function doesn't take the consecutive cell, but the relative one.
I want to get a result like the bold part in the example file (and avoid DELAY : 8001, 8002 as well)

How can I do that?

Thank you

For the first row of each group of rows, use

Formula:

Please Login or Register  to view this content.

Values as displayed

	A
1	DELAY : 352000
2	Mouse : 1843 : 824 : Click : 0 : 0 : 0
3	Mouse : 0 : 0 : Click : 0 : 0 : 0
4	Keyboard : Down : KeyPress
5	DELAY : 8000
6	Mouse : 1283 : 72 : Click : 0 : 0 : 0
7	DELAY : 181000
8	Mouse : 1843 : 824 : Click : 0 : 0 : 0
9	Mouse : 0 : 0 : Click : 0 : 0 : 0
10	Keyboard : Down : KeyPress
11	DELAY : 8000
12	Mouse : 1283 : 72 : Click : 0 : 0 : 0

Underlying formulas

	A
1	="DELAY : "&INDEX(TIMES!$F:$F,(ROW()-1)/6+2)
2	Mouse : 1843 : 824 : Click : 0 : 0 : 0
3	Mouse : 0 : 0 : Click : 0 : 0 : 0
4	Keyboard : Down : KeyPress
5	DELAY : 8000
6	Mouse : 1283 : 72 : Click : 0 : 0 : 0
7	="DELAY : "&INDEX(TIMES!$F:$F,(ROW()-1)/6+2)
8	Mouse : 1843 : 824 : Click : 0 : 0 : 0
9	Mouse : 0 : 0 : Click : 0 : 0 : 0
10	Keyboard : Down : KeyPress
11	DELAY : 8000
12	Mouse : 1283 : 72 : Click : 0 : 0 : 0

Thank you!
Is there a way I can fill all the rows automatically just based on the first 6?

EDIT: I still get the value of F8 instead of F2

Try pasting the following into cell B1 on the macro sheet and then dragging the fill handle down:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.