To fill cells with data that follows a pattern or are based on data in other cells.
Let’s do some coding around to do the same:
Sub AutoFill() Range("A2").AutoFill Destination:=Range("C2:A26"), Type:=xlFillDefault End Sub
The above code will apply on below source:
Post code execution the output will look like as follow and perform AutoFill:
Please leave your valuable comments