Hi there,
I need to copy a range from one sheet 'Master' and paste it to another sheet 'Log' once per day at a set time, lets say 7am each day.
Please see sample workbook.
Thank you
Hi there,
I need to copy a range from one sheet 'Master' and paste it to another sheet 'Log' once per day at a set time, lets say 7am each day.
Please see sample workbook.
Thank you
Put these in one of your numbered code modules.
Trigger will set the ontime macro to call the copy macro at 7 AM. When the copy macro runs, it will then call the Trigger macro to reset the on time call for the next day.Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Brilliant Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks