+ Reply to Thread
Results 1 to 7 of 7

match data form sheet1 and sheet2 and extract it out

  1. 12-25-2013, 01:54 AM #1
    mathanraj76
    mathanraj76 is offline
    Forum Contributor
    Join Date
    10-02-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2016
    Posts
    140

    match data form sheet1 and sheet2 and extract it out

    Hi..
    I need help

    I have a data in sheet1 in and sheet 2
    where i need compare both and extract data from sheet 1 into output sheet
    those data which not match will remain same in sheet1

    I have attached sample data..


    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-25-2013, 04:07 AM #2
    patel45
    patel45 is offline
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: match data form sheet1 and sheet2 and extract it out 

    Please Login or Register  to view this content.
    If solved remember to mark Thread as solved
    Reply With QuoteRegister To Reply
  3. 12-25-2013, 04:37 AM #3
    mathanraj76
    mathanraj76 is offline
    Forum Contributor
    Join Date
    10-02-2012
    Location
    malaysia
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: match data form sheet1 and sheet2 and extract it out

    hi..thanks..

    But when i run the code nothing is happen in sheet output..
    No data which cut and paste into sheet output..
    where it's match from sheet 2 in (column b) with sheet 1 in (column A)

    Thanks
    Reply With QuoteRegister To Reply
  4. 12-25-2013, 06:37 AM #4
    patel45
    patel45 is offline
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: match data form sheet1 and sheet2 and extract it out

    did you put the code in a module ? not in worksheet or workbook.
    If problems attach again the new workbook with code
    Reply With QuoteRegister To Reply
  5. 12-25-2013, 07:00 AM #5
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: match data form sheet1 and sheet2 and extract it out

    Hi, mathanraj76,

    if you run the code on your sample no action may be taken as there is nothing to be moved in Sheet1.

    I guess it would be a lot easier to drop the blank rows in sheet1 prior to running the macro. If you donīt want that change the value for cblndDEL_BLANKS to False:

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  6. 12-25-2013, 10:00 AM #6
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: match data form sheet1 and sheet2 and extract it out

    @ HaHoBe,

    I think your guess might be spot-on !!!

    Kind regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Reply With QuoteRegister To Reply
  7. 12-25-2013, 10:42 AM #7
    Winon
    Winon is offline
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: match data form sheet1 and sheet2 and extract it out

    @ HaHoBe,

    Thank you for the Rep.

    Ich danke Ihnen sehr.

    Merry Christmas my friend !!!

    Kind Regards.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2
    By annielle_09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  2. [SOLVED] Copy and Paste Entire Row from Sheet1->Sheet2 based on text string match in Sheet1 Row
    By dmlovic in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2012, 08:42 AM
  3. [SOLVED] Compare 2 cells in 2 sheets, if both match append data in Sheet2 to Sheet1
    By furious0331 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2012, 01:05 AM
  4. To Extract data from sheet1 to sheet2
    By RAJUHULIYA in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 05:04 AM
  5. Extract Data from Sheet1 and rearrange in Sheet2
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-06-2011, 01:27 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1