+ Reply to Thread
Results 1 to 6 of 6

How do I make a table automatically copy itself daily?

  1. #1
    Registered User
    Join Date
    06-22-2022
    Location
    Birmingham,England
    MS-Off Ver
    2007
    Posts
    6

    How do I make a table automatically copy itself daily?

    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.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,105

    Re: How do I make a table automatically copy itself daily?

    You may add such code to ThisWorkbook module:
    Please Login or Register  to view this content.
    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
    (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.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-22-2022
    Location
    Birmingham,England
    MS-Off Ver
    2007
    Posts
    6

    Re: How do I make a table automatically copy itself daily?

    Thankyou so much for this.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,105

    Re: How do I make a table automatically copy itself daily?

    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.

  5. #5
    Registered User
    Join Date
    06-22-2022
    Location
    Birmingham,England
    MS-Off Ver
    2007
    Posts
    6

    Re: How do I make a table automatically copy itself daily?

    I have tried entering this code and keeps saying the subscript is out of range ,whys that?

  6. #6
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,105

    Re: How do I make a table automatically copy itself daily?

    Probably you don't have a sheet named Data.

    Have you seen the sample file?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Help with daily averaging and automatically adding a worksheet copy?
    By AmyV1 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 01-13-2022, 05:59 PM
  2. [SOLVED] How to make excel automatically accommodate the new data in table
    By yarlachiru in forum Excel General
    Replies: 9
    Last Post: 09-08-2021, 10:06 AM
  3. How to make the Excel sheet automatically change it's data source daily?
    By FB111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-25-2019, 12:18 AM
  4. Replies: 1
    Last Post: 09-25-2019, 12:18 AM
  5. Make Table Automatically Expand Rows NOT Columns
    By Yanezez in forum Excel General
    Replies: 1
    Last Post: 02-23-2016, 05:08 AM
  6. [SOLVED] How to make Macro to lock certain cells connected to another cells value, then copy daily
    By RamiSaydi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2014, 12:41 PM
  7. Automatically Save and Copy Values Daily with a Date Stamp
    By cckal in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-10-2010, 05:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1