Newbie VBA/Macro Autofill query

[jake_wolf]

Hi all - newbie here with a VBA/Macro query.

I've put my query into an example image - I've found it easier to explain this way. Any help would be greatly appreciated

 

[RustamMika]

Hi jake_wolf

Try

Sub MMM()
    lr = Cells(Rows.Count, 1).End(xlUp).Row
    Selection.AutoFill Destination:=Range("B2:B" & lr)
End Sub

 

[kevin9999]

Or in one line

Sub MMM()
    Selection.AutoFill Destination:=Range("B2:B" & Cells(Rows.Count, 1).End(xlUp).Row)
End Sub