Which Excel function shall I use

 Trowa -
I need you a great help. I want to input every updated data in cell A1 in sheet 1 every day, for example, but I want all old data were input in A1 of sheet 1 to be recorded in colum B in sheet 2. how can I do this?

Many thanks


1 reply

Dear Sir,

Does that mean that sheet 1 and 2 are the only sheets that you will be using?

This will mean that other previous data will be erased.

Is that what you want?

Thanks in advance.
Dear Sir,

Thanks for your reply.

I only use two woeksheets, sheet1 and sheet 2. I want to update data every day in cell A1 in sheet1, B1, C1 etc is same way but for diffirent data.
because everytime i type new data into A1, B1...., the old data will be eraesd. But I still want to keep those old data for future studing. That's why I use sheet2 to keep those data eraesed in sheet1.

what I want is that I want data can be auomatic transfered from sheet1 to sheet2 when I input new data, sheet 2 will not like sheet 1 eraes data, but keep all data ereased in sheet1.

there is any way I can do it. thanks

> james
Hello James,

I can't think of a function which will do the job so try this VB code:

Sub test()
Worksheets("sheet1").Cells(1, 1).Copy
Worksheets("sheet2").Cells(Rows.Count, "a").End(xlUp).Offset(1, 0).PasteSpecial
Application.CutCopyMode = False
End Sub

This code will copy the contents of cell A1 of sheet1 and paste it at the bottom of the generated list on sheet2.

Is this what you were looking for?

Best regards,