Transferring Data Based on Date/Age to Another Sheet

  • I am in need of assistance to identify the age of a row based on an entered date and once the entry is 365 days, to move it to another sheet within the workbook. I have several columns of data within each row and want to identify when it ages to 1 year old, and have it automatically moved from the main sheet to an archive sheet within the same workbook. If needed, there is data in columns A through M, the date for each row is in column C and entries run from row 2 through 51,000.

    I cannot seem to find anything in VBA or a macro that matches exactly what I am trying to do and have attached the file that I am trying to set this up in.

    Thank you for any guidance or assistance.

  • Re: Transferring Data Based on Date/Age to Another Sheet

    You can try this.

    It needs to be installed in the worksheet module for the "Associate Tracker" worksheet.

    The attached file has it installed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!