In Sheet1 I have a value in cell C70 in that is calculated using formulas based on cells D11 to D19.
When a value in cells D11 to D19 is altered, I want cell C70 to be appear in cell A2 in Sheet2
When a value in cells D11 to D19 is altered again, I want the new value in C70 to appear in cell A3 in sheet 2 (i.e. below the previous value)
etc
So far I have
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$C$70" Then Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1) = Target.Value
End Sub
However this only works when C70 is changed, not D11 to D19. How do I change the above formula to do this.
Thanks
Bookmarks