Skipping 13 rows while dragging a formula

I would like my spreadsheet to be able to do the following:

A1=12
A14=A1-7
A27=A14-7

Can someone please help me figure out how to make this happen . Thanks.

I want A2 to be blank.

I essentially want to start dragging at A14 I guess.

A1=12
A2=BLANK
A3 .
A4 .
A5 .
A6 .
A7 .
A8 .
A9 .
A10 .
A11 .
A12 .
A13 .
A14=A1-7
A15=BLANK
A16 .
A17 .
A18 .
A19 .
A20 .
A21 .
A22 .
A23 .
A24 .
A25 .
A26 .
A27=A14-7
and so on from there

is there a way to make them blank? I need to put other formulas in cells between these cells. I am making a series of the same table where the data is based on what week it is.

Not sure if this works, but give a try.

In A1 enter 12.

In A2 enter =a1-7

Select only A2 and drag down per your need.

Now select the range and use the below macro to insert 12 rows in between..

Please Login or Register  to view this content.

* This VBA code is not mine. I got this code from a website ( forgot from which site )years back when i had similar issue

Example attached