+ Reply to Thread
Results 1 to 2 of 2

Trying to auto move rows to 2nd tab if column meets criteria!!

  1. #1
    Registered User
    Join Date
    12-18-2019
    Location
    Minnesota
    MS-Off Ver
    2010
    Posts
    1

    Question Trying to auto move rows to 2nd tab if column meets criteria!!

    Example sheet.xlsx

    (Please see attachment for reference)

    The attached image is an example of an excel sheet used to keep track of due dates.

    In the attachment, column G shows the due date for the job specified in column A. I would like create a formula, use vba, or anything so that if the date specified in column G is one month or less from today's(the current) date, the entire row will then be copied and moved to a second tab. Even better, I'd love to add in something that will organize them so that the rows with the closest upcoming due date show at the top.

    I've been using my knowledge, reading guides and watching YouTube videos trying to figure this out and have not made very much progress Any help would be GREATLY appreciated!!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,494

    Re: Trying to auto move rows to 2nd tab if column meets criteria!!

    There is a difference between "copying" and "moving" - the latter implies that the record is removed/deleted from the first sheet, whereas the former implies that a copy of the record appears on the second sheet but that the original record remains in the first sheet.

    If you use a formula solution, then the record would be copied to the second sheet, and the original data would remain intact. Would this be suitable for you?

    In your file, are the grey-coloured records the ones you would expect to appear on the second sheet?

    Hope this helps.

    Pete

+ 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. How to count rows where one column meets criteria based on another column
    By gavsenior in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2018, 07:30 AM
  2. Trying to Move Data From One Sheet to Another If it Meets Criteria
    By Needhelpers in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2015, 05:08 PM
  3. [SOLVED] copy column headers into rows if it meets a specific criteria
    By melody10 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-30-2013, 06:05 AM
  4. Need one column total if criteria meets another columns criteria
    By jebrown in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-24-2013, 08:47 PM
  5. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  6. Automatically Move Rows When one Column meets a Criteria
    By Apokolips in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-24-2013, 09:55 PM
  7. Formula to move certain information in a column to a table that meets criteria?
    By MikeTruth in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-28-2012, 04:53 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