Simple copy a cell value to another cell on a spreadsheet that keeps refreshing

[breakbacktennis]

Hi Im looking for some simple code that copies the value is G9 to AK9. The spreadsheet i am working with keeps refreshing as it is connected to an application so i want the value to keep refreshing automatically also. Kind regards.

 

[Logit]

.
If you mean that the value in G9 continually changes ...

In AK9 enter

=G9

 

[breakbacktennis]

.
If you mean that the value in G9 continually changes ...

In AK9 enter

=G9

I meant by using a macro as there is more detailed backstory that a macro needs to be used

 

[Logit]

.
Paste into the Sheet Level Module (the affected sheet) :

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$G$9" Then
        Range("AK9") = Range("G9")
    End If
End Sub