+ Reply to Thread
Results 1 to 2 of 2

Compare sheet1 row with all the rows with sheet 2

  1. #1
    Registered User
    Join Date
    03-21-2009
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    60

    Compare sheet1 row with all the rows with sheet 2

    Hi Friends,

    I have written a macro for comparing sheet1 with sheet2, it is comparing sheet1's row with sheet2's row and if the row is not matching with sheet row then the the entirerow from sheet2 will be moved to third sheet3.

    my requirement is a row from sheet1 needs compare all the rows in the sheet3 and unmatched rows needs to be copied to sheet3


    Please kindly modify my attached macro or provide the logic.


    Thanks & Regards
    Ram
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Compare sheet1 row with all the rows with sheet 2

    Hi ramserp,

    Can you clarify the sheet numbers to sheet names?
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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