I have a set table for things that I have to log on a daily basis,can someone help me automate the process of copying itself,and it’s contents into a new worksheet daily(titled via date as it is to be used daily and the review of past records is important in the situation it will be used in) before clearing the cells to receive that days data.
You may add such code to ThisWorkbook module:
On opening a file (morning given day I assume) the current content of Data sheet is copied to a newly created sheet named by that day: YYYYMMDD
Please Login or Register to view this content.
(may be it would be wise to save the file automatically in that moment, but on the other hand, if you make some changes and don't save the file - the situation is still the same as before opening first time given day)
If the file is closed and opened again that day the presence of YYYYMMDD sheet is tested and if it is present is left as it was.
See sample file (recycled from one of other threads).
Download the file and open, but not allow the macros. It just contains Data and 20220622 sheets. close it and open once again allowing macros - the content of DAta will be copied to 20220623 and DAta will be the active sheet.
Best Regards,
Kaper
Thankyou so much for this.
Test it (may be few days?) and if it works as expected, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
I have tried entering this code and keeps saying the subscript is out of range ,whys that?
Probably you don't have a sheet named Data.
Have you seen the sample file?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks