+ Reply to Thread
Results 1 to 2 of 2

Macro/VBA to Auto Archive data to new sheet

  1. #1
    Registered User
    Join Date
    11-02-2018
    Location
    London, England
    MS-Off Ver
    Microsoft excel 2013
    Posts
    1

    Question Macro/VBA to Auto Archive data to new sheet

    Hi there,
    I would be grateful if anyone could possibly help?

    I currently have one sheet on excel where action points are kept for review. After 5 years, these action points no longer need to be reviewed and I want to insert a macro /VBA where the whole row of data will automatically archive to the separate "archive" sheet after the implementation date has passed 5 years.
    The actions also need to be 5 years by year only, not exactly 5 years (1825 days) from today's date. For example, as it is 2018, I need to keep data for 2013, 2014, 2015, 2016, 2017 and 2018. Once the 2019 year begins, I would like all of the action points from 2013, and related data on the row, to automatically archive to the "archive" sheet. This will leave me with data of action points from 2014 - 2019 (5 year period). Once the archived data has transferred to the "archive" sheet, I would like it to delete from the original sheet on the workbook. I would like this to be in place to ensure that staff do not carry on conducting time consuming reviews on data which is over the required 5 year time frame.
    I am having issues with creating a VBA to auto-archive anything date related, but especially year only related. Most of the examples I have seen are a certain time frame in days from today's date, which is not what I require. I want to archive any rows which contain a date (under the "date of publish" header) which is over 5 years from the current year.
    I would really appreciate any assistance with the above

    Many thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Macro/VBA to Auto Archive data to new sheet

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and click "manage attachments" to open the upload window.


    To add a file to a post

+ 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. Auto Archive rows to separate sheet but retain data validation in original sheet
    By chrisk67 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2016, 10:27 PM
  2. [SOLVED] Move row from sheet to archive in a macro
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2016, 09:58 AM
  3. Macro to copy a line to archive sheet and delete from active sheet
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-08-2015, 09:15 PM
  4. Auto Archive & Drop Down Macro Query
    By andy_marcos in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2013, 04:25 PM
  5. [SOLVED] Need a macro to copy dates & data from one sheet to an updating archive sheet
    By pbj in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-07-2013, 06:58 PM
  6. Replies: 2
    Last Post: 06-06-2012, 09:49 PM
  7. Help with VBA to auto archive data
    By Kayaness in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2012, 01:43 AM

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