Results 1 to 5 of 5

Thread: compare data ... Incomplete rubbish

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    compare data ... Incomplete rubbish

    (data are mobile numbers)

    I have a data in column A of sheet name abc

    i have one more sheet name def it also has data in column A

    i have one more sheet Fake Data that also has data in column A

    I have one more sheet Completed that also has data in column A

    I have one more sheet name Missing Data that also has data in column A

    now what i want is.....

    match column A of abc sheet with column A of def sheet if it matches then delete that data in column A of def and the data which are not matched compare that data with Fake Data and if matched then delete and again if there will be unmatched data then compare that data with complete data if found then delete and again if there will be unmatched data then copy that data and paste it to missing data sheet in column A and delete all the data in def

    all this i have to do by vba only so plz help
    Attached Files Attached Files
    Last edited by DocAElstein; 06-24-2020 at 02:31 AM.

Similar Threads

  1. compare two tables
    By emmye998 in forum Excel Help
    Replies: 1
    Last Post: 03-24-2014, 04:25 AM
  2. Compare values between the two columns by condition
    By mahmoud-lee in forum Excel Help
    Replies: 2
    Last Post: 03-15-2014, 07:54 AM
  3. compare column a to b and b to a
    By ayazgreat in forum Excel Help
    Replies: 18
    Last Post: 05-07-2012, 04:46 PM
  4. Replies: 1
    Last Post: 11-11-2011, 02:06 PM
  5. Compare two worksheets and List Differences
    By excel_learner in forum Excel Help
    Replies: 1
    Last Post: 11-02-2011, 10:03 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •