Copying results in another cell

Question

How can I have excel automatically copy the changes in a cell that has formulas into one that doesn't? For example, I have a formula on D18. Every time this value changes in D18 I want it to be updated in cell D4.

I would need this to be explained to me as if I were a child since I am no expert in Excel. Thank you

hansvogelaar · Answer

yennifel&nbsp;
The easiest way to do this, is to enter the formula
&nbsp;
=D18
&nbsp;
in cell D4.
If you don't want a formula in D4 for some reason, you'll need VBA code.

Right-click the sheet tab.
Select 'View Code' from the context menu.
Copy the code listed below into the worksheet module.
Switch back to Excel.
Save the workbook as a macro-enabled workbook (*.xlsm).
Make sure that you allow macros when you open the workbook.
Warning: macros only work in the desktop version of Excel for Windows and Mac. They don't work in Excel Online (the version in the browser), nor on Android or Apple phones/tablets.

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
    On Error GoTo ErrHandler
    If Not Intersect(Range("D18"), Target) Is Nothing Then
        Application.EnableEvents = False
        Range("D4").Value = Range("D18").Value
    End If
ExitHandler:
    Application.EnableEvents = True
    Exit Sub
ErrHandler:
    MsgBox Err.Description, vbExclamation
    Resume ExitHandler
End Sub

yennifel · Answer

Hi,&nbsp;HansVogelaar&nbsp;&nbsp;Thank you for your prompt response. I actually found a baby way to do it. I right-clicked on cell D18 (the one with the formula) and pasted it with the "paste link" option in cell D4 and the trick worked.&nbsp; I did it with all the other cells I wanted and it was magic.&nbsp;I appreciate this. Maybe I will need this in the future.&nbsp;&nbsp;

Forum Discussion

Copying results in another cell

Share

Resources