Cell references absolute or relative

Robbie_Goodwin 

If you can't make the cell references absolute ($A$2 instead if A2), Sergei's tip is the best you can do without VBA.

You might use the following macro. If you store it in a module in your personal macro workbook Personal.xlsb, it will be available in all workbooks, and you can assign it to (for example) a Quick Access Toolbar button.

Sub CopyFormulas()
    Dim rngSource As Range
    Dim rngTarget As Range
    On Error Resume Next
    Set rngSource = Application.InputBox(Prompt:="Select the source range", _
        Default:=Selection.Address, Type:=8)
    If rngSource Is Nothing Then
        Beep
        Exit Sub
    End If
    Set rngTarget = Application.InputBox(Prompt:="Select the target range", _
        Type:=8)
    If rngTarget Is Nothing Then
        Beep
        Exit Sub
    End If
    rngTarget.Formula = rngSource.Formula
End Sub