vba code for excel file

[klpw]

I'm creating a worksheet name 'current' in which the data is extracted from the server. When server adds new information, new row of these information needs to be appeared in the 'current' worksheet at the last row and shows 'new' in first column. User can update new information from the 'current' worksheet by column and 'new' needs to be shown in first column as well. The 'new' needs to be amended everyday. At the same time, I would like to create another worksheet which named as 'past'. In 'past' worksheet, all the data in 'past' worksheet will be automatically transferred to 'yesterday' worksheet about 7pm each day which is being updated everyday as well. Please help.

Thanks a lot.

[westconn1]

there is a recent thread that does several of these things see if it helps at all
http://www.vbforums.com/showthread.p...s-over-a-range

[klpw]

Hi westconn1, I've had a look at the thread you suggested and amended my code according to it. However, it doesn't seem to update the information for the time I set it to be. Would you mind helping me to check my code? Hope to hear from you soon.

Sub copypaste_RECENT()

Sheets("t").Range("B:V").Copy Destination:=Sheets("y").Range("B:V")

Application.OnTime Now + TimeSerial(12, 45, 0), "copypaste_RECENT"

End Sub

[westconn1]

is this procedure in a std module or an object module

[klpw]

Hi westconn1, the procedure is in standard module.

[westconn1]

is every 12¾ hours the correct schedule? or should it be something different?

if it is 12:45 pm, then it should not be adding the time to now

[klpw]

Hi westconn1, it's 12.45pm. Do you meant I should use Date instead of Now?