+ Reply to Thread
Results 1 to 2 of 2

Extracting lines with changed data between sheets

  1. #1
    Valued Forum Contributor scaffdog845's Avatar
    Join Date
    02-01-2008
    Location
    Aston, PA. USA.
    MS-Off Ver
    Microsoft 365
    Posts
    373

    Extracting lines with changed data between sheets

    Hi all,

    I'm not sure whether this would be a formula or a VBA issue. I'm attaching a small example sheet to help with clarification.

    'Data 1! contains an SAP dump with dates from 1/1/09 to 4/30/10
    'Data 2! contains an SAP dump with dates from 1/1/09 to 5/31/09

    I'm looking to do two things.
    1. Extract all lines that have have a matching WO Number (D2:D25000) on 'Data 1! and 'Data 2! AND have the User Status (E2:E25000) changed from anything other than "FC", "FCAA" or "FCHP" on 'Data 1! to "FC", "FCAA" or "FCHP" on 'Data 2!

    2. Extract all lines from 'Data 2! that do not have a matching WO Number on 'Data 1! AND have a User Status of "FC", "FCAA" or "FCHP"

    I've highlighted the expected results on 'Data 1! and 'Data 2! and manually copied them to the 'Expected Outcome! sheet.

    The current full sets of data contain over 12,000 records and could grow as large as 25,000, possibly more depending on how far back in time the query that creates the sheets is set to run.
    Attached Files Attached Files
    Last edited by scaffdog845; 06-09-2010 at 08:24 AM.
    Click here to read the Forum Rules
    Whatever it is in life you decide to go after, go after with great ferocity.

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628

    Re: Extracting lines with changed data between sheets

    See attached file where I added this macro:
    Please Login or Register  to view this content.
    Regards,
    Antonio
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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