Macro to autofill formulas

[RattlingCarp3048]

Hello, help please!

I have a macro created to copy/paste data A-Q from one sheet to another. What I want to happen is after it pastes the data in A-Q, remove the duplicates from Column U and autofill/drag the formulas from V-X down. The last row with formulas in it will be different everytime the macro runs.

Ex. Right now the last row with formulas is row 7225. Tomorrow the last row of formulas might be 5430, and so on changing every day depending on the data.

Any thoughts?

 

[offthelip]

try this:

Sub test()
    lastRow = Cells(Rows.Count, "A").End(xlUp).Row
    Range("v1:x" & lastRow).Formula = Range("v1:x1").Formula
End Sub

 

[RattlingCarp3048]

try this:

Sub test()
    lastRow = Cells(Rows.Count, "A").End(xlUp).Row
    Range("v1:x" & lastRow).Formula = Range("v1:x1").Formula
End Sub

That worked beautifully!!