Results 1 to 4 of 4

Thread: Automatically Archive Historic Or Old Data Based On Ageing Date

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-24-2013, 03:45 PM #1
    peter renton
    peter renton is offline
    Member
    Join Date
    May 2013
    Posts
    84
    Rep Power
    12

    Automatically Archive Historic Or Old Data Based On Ageing Date

    Hi

    I have attached a small sample sheet

    I dont know if this is possible but i would like to remove a complete row and place it in the next available
    row in a sheet called archive if the date in columd H is say 12 months after todays date and then if possible
    delete it from the archive sheet if its say 18 months past todays date.

    the list continues to grow and i was hoping for a way to self clean the data


    Thaks for any help
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Ageing Monthly Bracket Calculator
    By msiyab in forum Excel Help
    Replies: 9
    Last Post: 07-01-2013, 12:50 PM
  2. Group And Transpose Data Based On Sections of Data
    By theladysaphir in forum Excel Help
    Replies: 5
    Last Post: 06-28-2013, 07:55 AM
  3. Data Validation For Selecting Date And Week Number
    By paul_pearson in forum Excel Help
    Replies: 8
    Last Post: 06-16-2013, 05:07 AM
  4. Lookup Start Date And End Date Range For Specific Date Using Formula
    By mahmoud-lee in forum Excel Help
    Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  5. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 PM

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
  •  

Forum Rules