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 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.
????? thats not clear where is the formula going ? whats in a2?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I essentially want to start dragging at A14 I guess.
I want A2 to be blank.
i still dont see it ,so what does a15 contain?
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
well the intermediate columns wont be truly blank as they will have a formula in them
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..
* This VBA code is not mine. I got this code from a website ( forgot from which site )years back when i had similar issueSub InsertRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Call") If InsQuan <= 0 Then MsgBox "Invalid number entered", vbCritical, "Stop!" Exit Sub End If Application.ScreenUpdating = False Do Until Selection.Value = "" ActiveCell.Offset(1, 0).Range("A1:A" & InsQuan).Select Selection.Insert Shift:=xlDown ActiveCell.Offset(InsQuan, 0).Select Loop [A1].Select Application.ScreenUpdating = True End Sub
Example attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks