Need help: creating a list based on a single dynamic cell

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.

Have you tried using the Worksheet_Calculate event instead?

It's also a good idea to turn off events while an event macro is running to prevent new instances being run.

Application.EnableEvents =False
....
Application.EnableEvents =True

Try

Private Sub Worksheet_Calculate ()
Application.EnableEvents =False
Sheet2.Range("A" & Rows.Count).End(xlUp).Offset(1, 0) = Sheet1.Range("A1")
Application.EnableEvents =True
End Sub

.hi i tried it but didnt work. I put your code on module, but i change A1 from sheet 1 number several times, it didnt create my list on sheet 2 with these different numbers unfortunately. So do you got any idea how to make it work, Thanks for your time.

heeeelp heeeelp heeeelp heeeelp heeeelp heeeelpheeeelpheeeelpheeeelpheeeelp

yes, i have a cell that continuousily change it's values, so i need a code that automatically grab this dynamic cell number on D1, and so every new numbers on D1 that changes, from the previousily like now is 10 next it show 20, in the cell will be stored in order on A column these numbers like for example .First line 10 then line 2, show 20

yes sir, forming a list with these numbers. I got a old code, but i needed to press enter for every new record on collumn A. If you could
solve this problem i'll be very thankfull