HI friends, i needed a vba macro code that automatically creates a list, from A1 to A2 an so on, based on values of another cell C1 that constantly changes it's values, every 1 second. i tried this code: 

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target = Range("C1") Then
        Sheet2.Range("A" & Rows.Count).End(xlUp).Cells(2, 1) = Sheet1.Range("A1")
    End If

But when i tried it, i needed to press enter every time i changes the values on C1 cell, if didnt press, it didnt create my list.

So can someone please help me in a code that doesnt need to press enter to progress the list, i dont know maybe automatically pressing enter button on c1 cell in a macro.

Thanks for any help.