How to Copy the value of a cell to another cell everyday at a specific time?

[bhavin99]

I have an excel sheet with a table which calculates a total and gives me a total number which increases everyday as the table changes. I want to copy that total number to another table on the sheet daily... so as to create a sort of daily list of totals (So that I can calculate the difference between the value today & value yesterday). Is there any way to automatically copy the value daily at a specific time?

For further clarification, I have added an dummy excel sheet representing my scenario as Day0, Day1, Day2 (Day 1 & 2 represent how the Day0 sheet should appear on Days 1 & 2)

Any help is greatly appreciated.

[bhavin99]

BUMP.. still no reply? Can somebody plz help me with this? If everyday at a specific time is not possible, then its okay even if that value copy occurs whenever the date changes.

[bhavin99]

Still No reply? Do I need to post further clarification or is there no solution for this?

[watersev]

hi, bhavin99, please check attachment, set the time for copying process in Workbook model. On workbook open the "copy-paste" event is scheduled to the specified time. On closing this workbook, the "copy-paste" event is cancelled. Hope this helps.

PS. Tis is one of the options. For more details see VB help for Ontime method

[bhavin99]

Thanx for the reply... But I am sorry that Ï dont understand what you mean by "set the time for copying process in Workbook model"

And I checked out the Ontime method, but I dont seem to understand how I would be able to copy to a new row everyday

A bit of clarification:
I want that at the end of everyday the total should be copied to a new row (the bottom-most row) in the Daily table, like
25th april ... 201
26th April... 245
27th april... 304

I Hope you can help me with it.