Help updating other cell

  • Thread starter Thread starter tommyboy
  • Start date Start date
T

tommyboy

basically what i want is when a cell changes i want it to update anothe
cell on a separate sheet with the new value, Then to the 2nd time i
changes i want it to update the 2nd cell down and to continue doin
this down the column


any help pleas
 
right click sheet tab of source sheet>view code>insert this.
Now, when you change cell B4, col A of sheet 17 will be appended.

Private Sub Worksheet_Change(ByVal Target As Range)
With Sheets("sheet17")
x = .Cells(Rows.Count, "a").End(xlUp).Row + 1
If Target.Address = "$B$4" Then .Cells(x, "a") = Target
End With
End Sub
 
that worked a treat

but the cell that changes is from external txt file, and when data i
refreshed even though the cell b4 changes it doesnt update sheet 17


any idea
 
You may have to use the worksheet_calculate instead AND in an unused cell
type in =now() to make it calculate
 
Back
Top