_:n1e1abb36c5a24fa6ad31a436b879c346xb1
<http://schema.org/text>
"I need a macro that will take the formula from cells J2 and K2 and autofill them below. The formula for the part of spreadsheet pictured below would be\n\nSub autofill()\n    Range(\"J2:K2\").Select\n    Selection.autofill Destination:=Range(\"J2:K7\"), Type:=xlFillDefault\nEnd Sub\n\nThe problem is it's not always seven rows.\nPlease help.test.xlsGHIJK1PartNameQtyOrderedQtyDespatchedAnalysis1Analysis22ENDCAPMOULDIN410004150LateUndersupply3ACCELERATORPAD140014004CLAMPHTSNORKE260020005GRILLELARGEBE12126GRILLELARGEGR36367C/POSTLARGEGR81100Wednesday 17-09-02"
<https://www.mrexcel.com/board/threads/macro-for-autofill.21863/>