Fill down cells that corespond in a different workshhet

[Fin Fang Foom]

I have this code below. It fills down that coresponds in coulmn A.
The problem is I would like to fill down M9:N in worksheet 2 that coresponds in worksheet 1 of column A.

Is that possible ?

 Sub Filldown()
x = Range("A65536").End(xlUp).Row
  
    Range("M9:N" & x).FillDown
End Sub

 

[Fin Fang Foom]

Well I found what I'm looking for.

Sub test()
     
'   Count rows on sheet 2
    Dim myLastRow As Long
    Sheets("Sheet1").Select
    myLastRow = Range("A65536").End(xlUp).Row
    
'   Copy formulas on sheet 1
    Sheets("Sheet2").Select
    With Range("M9:N" & myLastRow)
        .FillDown
        .Copy
        .PasteSpecial Paste:=xlPasteFormulas
    End With
    Application.CutCopyMode = False
    Sheets("Sheet1").Select
    Range("C8").Select
     
End Sub