Closed Thread
Results 1 to 2 of 2

How to Copy 2sheets Matched Rows only to New Sheet

  1. #1
    Forum Contributor
    Join Date
    04-11-2017
    Location
    Madurai
    MS-Off Ver
    2016
    Posts
    155

    How to Copy 2sheets Matched Rows only to New Sheet

    I have 2 excel sheets here i want to copy matched rows only and i want to paste it to another new sheet. How ?
    Say Easy method. I have 3Lakhs rows so i have attached sample file here
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    21,379

    Re: How to Copy 2sheets Matched Rows only to New Sheet

    You already have a thread running on this issue: https://www.excelforum.com/excel-new...p-formula.html

    You should know this forum's rules by now: no duplicate threads.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

Closed 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