+ Reply to Thread
Results 1 to 2 of 2

Automatically moving data from sheet to sheet

  1. #1
    Registered User
    Join Date
    02-03-2017
    Location
    Cincinnati, OH
    MS-Off Ver
    365
    Posts
    4

    Automatically moving data from sheet to sheet

    Good afternoon all,

    I'm pretty new to using Excel for more than basic list and math functions, so this may be a basic question, maybe not. I don't know.

    I use Excel to list and track workorders in my shop.

    My page is pretty basic:
    Column A: Customer
    Column B: Customer email
    Column C: Department
    Column D: Date in
    Column E: Date out
    Column F: Description

    What I'd like to do is set Excel up so that once the "Date out" hits 60 days past, the entire line containing that date will automatically move to a similar list on a second sheet within the same .xls file.
    I've been doing this manually, but I'm hoping it can be automated.

    Any ideas?

  2. #2
    Registered User
    Join Date
    06-24-2016
    Location
    Slovakia
    MS-Off Ver
    MS Office 365
    Posts
    92

    Re: Automatically moving data from sheet to sheet

    Hello rponton,
    if you don't want to do it using VBA than I suggest to add one more column where you can calculate number of days past using formula =today() - value in cell E .
    Than you can use Advanced Filter and filter those lines that have more than 60 days in column E.
    If you can attach here a sample workbook ( you can attach files when you click on button "Go Advanced" and than scroll down and click on "Manage Attachments") I can help you to do it
    Have a fantastic day

+ 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. Moving complete rows of data from one sheet to a new sheet when a date is entered
    By meadnl89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2014, 11:39 AM
  2. moving data feed data into a new sheet and doing this automatically
    By leon1233 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2013, 02:09 PM
  3. Moving information from one sheet to another automatically
    By BenJohnson in forum Excel General
    Replies: 1
    Last Post: 10-24-2012, 09:33 AM
  4. Replies: 4
    Last Post: 04-08-2011, 11:42 PM
  5. Replies: 1
    Last Post: 04-07-2011, 03:44 PM
  6. Replies: 2
    Last Post: 03-23-2009, 10:17 AM
  7. [SOLVED] Moving data from one sheet to another automatically
    By holyman in forum Excel General
    Replies: 2
    Last Post: 07-04-2006, 09:50 AM

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