Well you could use a cell that says the last time the data was transfered,
and then add an event on activeworkbook.open that will transfer the data if
the system date is superior to the wirtten date in the cell.
For the comparition use 'vba.datediff("d",date1,Now)' where date1 is the
date where the data were last archived.


"homezz69" wrote:

This might be a more complicated question than I realise. However I want to
insert a 24hr clock into (a) worksheet(s). Data in one sheet must be
transferred to another worksheet after the day is complete. So I can start
entering new data the next day. Can this be created? Please advise.