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
Sub autofill()
Range("J2:K2").Select
Selection.autofill Destination:=Range("J2:K7"), Type:=xlFillDefault
End Sub
The problem is it's not always seven rows.
Please help.
Sub autofill()
Range("J2:K2").Select
Selection.autofill Destination:=Range("J2:K7"), Type:=xlFillDefault
End Sub
The problem is it's not always seven rows.
Please help.
test.xls | |||||||
---|---|---|---|---|---|---|---|
G | H | I | J | K | |||
1 | PartName | QtyOrdered | QtyDespatched | Analysis1 | Analysis2 | ||
2 | ENDCAPMOULDIN | 41000 | 4150 | Late | Undersupply | ||
3 | ACCELERATORPAD | 1400 | 1400 | ||||
4 | CLAMPHTSNORKE | 2600 | 2000 | ||||
5 | GRILLELARGEBE | 12 | 12 | ||||
6 | GRILLELARGEGR | 36 | 36 | ||||
7 | C/POSTLARGEGR | 81 | 100 | ||||
Wednesday 17-09-02 |