Offset command question

[motionbuddy]

Hello,

I just cannot seem to get the offset command working for me. Any assistance would be appreciated

I am trying to get H5=A1 and H6=A2 but then skip 8 lines for the H column so H13=A3 and H14=A4 then skip another 8 rows and repeat. Would the offset command work in this situation? How can I fill the formula in the H column if I have items in the skipped 8 rows that I do not want to modify?

Best

 

[StephenCrump]

How can I fill the formula in the H column if I have items in the skipped 8 rows that I do not want to modify?

Welcome to the Forum!

I assume you're looking for a VBA solution, as it sounds like you can't simply copy a formula down column H.

Perhaps something like:

Sub InsertFormulae()

    Dim lNoRows As Long, i As Long
        
    lNoRows = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To lNoRows Step 2
        Range("H" & 4 * (i - 1) + 5).Resize(2).Formula = "=A" & i
    Next i

End Sub