Forum Discussion
help for a formula
Hello, I need help for a formula, I would like that in the NAME column of my table the A goes to the two rows below (Line 10 and 11) then that the B is automatically put in column 13 and thus t...
Hello, thank you for your help but when I enter EXACTLY your formula, nothing happens... do you know why?
From your screenshot i can't tell why it doesn't work. You can compare the attached file maybe this is helpful.
An alternative could be these lines of code. In the attached file you can click the button in cell H2 to start the macro and the results are entered in column H.
Sub filldown()
Dim i As Double
Cells(9, 7).Value = Cells(9, 6).Value
For i = 10 To 1000
If Cells(i, 6).Value = "" Then
Cells(i, 7).Value = Cells(i - 1, 7).Value
Else
Cells(i, 7).Value = Cells(i, 6).Value
End If
Next i
End Sub