auto copy newly inputted data to another column

[djdave007]

Hi,
Is it possible to input data into a specific cell, say A2 on worksheet 1, and the data be automatically copied to columnA on worksheet 2, and listed.

e.g: If I enter a value of 5.01 in A2 (ws1), press return.
In the same cell type 10.3, return,
In the same cell type 20.5, return.

Then go to Worksheet 2, and listed in column A are:
5.01
10.3
20.5
Additionally, is it possible that whenever I enter a value in the cell A2, after pressing return, it clears ready for the next input?

I am trying to capture a long string of data on the same "cover" sheet without creating multiple documents so any help you can give would be most grateful.

thanks again
dave

 

[SteveO59L]

So, each time you enter in sheet1 A2, you want the value copied to sheet2 col a in the next available row ?

 

[djdave007]

yes...
eventually I want to be able to create charts from this raw data, but I need a way of cataloguing it.

 

[SteveO59L]

Something along the lines of

Private Sub Worksheet_Change(ByVal Target As Range)

Dim rng1 As Range
If Target.Row = 2 And Target.Column = 2 Then

lastrow = Range("c65536").End(xlUp).Row

Set rng1 = Range("c" & lastrow)

rng1.Offset(1, 0).Select
Selection = Target.Value


Target.ClearContents


End If

End Sub

 

[djdave007]

thank you very much.

exactly what I needed.

thanks again