How can I move data from one sheet onto another at a certain time?

Answer 1

This is an excellent question. I'd advise creating/recording a simple macro which copies data from Sheet 1 to Sheet 2. Next you'll want to edit this macro and insert the "Application.OnTime" VBA application object. This will allow you to schedule the macro to automatically run at your specified time and date in the future.

If this is a procedure you will be performing regularly, I'd suggest having the macro prompt you for variable inputs such as the date and time you want to run the module next.

For details on the syntax of this object and how to use it, I'd suggest visiting:

https://docs.microsoft.com/en-us/office/vba/api/excel.application.ontime