Consulting

Results 1 to 14 of 14

Thread: Delete the Value in Sheet 2 that does not exist in Sheet 1

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Feb 2012
    Posts
    406
    Location

    Delete the Value in Sheet 2 that does not exist in Sheet 1

    Hi Everyone , I need your help again .
    I have 2 Sheet , Sheet 1 and Sheet 2 and i want delete the value in the sheet2 are not exist in same row cell in Sheet1 For Example

    Sheet 1 in A1 We have :

    SHeet1 A1
    1|1002|25|4|5|85|Apple|Banana
    and in Sheet2 A1
    25|60|90|40|1002|1|Banana
    I need This result in Sheet 2 :

    25|1002|1|Banana
    I attached The sample Also .

    Really appreciate for your time and effort.
    Attached Files Attached Files

Posting Permissions

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