Hello all,
I am trying to write a macro that will automatically move the date in row one down one row and insert the data in a different sheet into row one. The catch is I want the program to do this automatically for me each day at 5pm and 5am. Writting the macro to mvoe the data and insert and row is not hard but to make it do it automatically twice a day at 5 is a little above my level. Any help would be greatly appreciated.
Regards,
Tom
I am trying to write a macro that will automatically move the date in row one down one row and insert the data in a different sheet into row one. The catch is I want the program to do this automatically for me each day at 5pm and 5am. Writting the macro to mvoe the data and insert and row is not hard but to make it do it automatically twice a day at 5 is a little above my level. Any help would be greatly appreciated.
Regards,
Tom