Previous Topic Next Topic

Which Excel function shall I use

Closed
james - Oct 10, 2009 at 12:09 AM
 Trowa - Oct 12, 2009 at 08:14 AM
Hello,
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

JIm
Related:

1 response

Answer 1 / 1
Blocked Profile
Oct 10, 2009 at 02:04 AM
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.
0
james
Oct 10, 2009 at 07:35 PM
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
0
Trowa > james
Oct 12, 2009 at 08:14 AM
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,
Trowa
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses