copy down formula

[redspanna]

Hi all

Cell AC2 holds a certain number value that changes.

is there some code that will find the last populated cell in column Y and copy down the formula in that cell by the number of rows in cell AC2?

thanks

 

[JackDanIce]

Try:

Sub Assimilation ()
Dim i as Long, AC as Long
i = Range("Y" & Rows.Count).End(xlUp).Row
AC = Range("AC2").value
Range("Y" & i & ":Y" & i + AC).Filldown
End Sub

 

[redspanna]

Thank you