I have a workbook and need to automatically copy "Live data" from A1 and paste that data into B2 at 5:00 AM,
then, at the next hour (6:00 AM) paste the same updated data into B3 and so on..
stopping at B13, at 4:00 PM.
Then, each day at 5:00 AM clear the contents of B2-B13 and start again.
This workbook will be running 24/7.
Getting the Live data into A1 is not an issue for me.
Anyone's help would be very much appreciated.