+ Reply to Thread
Results 1 to 3 of 3

Take Input from sheet 1 and find relative records in sheet 2 ; copy found records in shet3

  1. #1
    Registered User
    Join Date
    12-20-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    1

    Take Input from sheet 1 and find relative records in sheet 2 ; copy found records in shet3

    Hi,

    I am new to Excel macro functions, My requirement is Take "Roll No" input from Sheet 1 ; One by one and find matches in Sheet 2; Copy those records in sheet 3;
    If the roll no occurs in one or more time all records should be updated in sheet 3.

    Can you please help me on Macro to full fill this .

    Please help.

    Attached: Sample Excel file

    Rgds
    Attached Files Attached Files
    Last edited by Jaijk; 12-20-2013 at 11:28 AM. Reason: To include more details

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Take Input from sheet 1 and find relative records in sheet 2 ; copy found records in s

    You can try this......
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,648

    Re: Take Input from sheet 1 and find relative records in sheet 2 ; copy found records in s

    See the attached sheet.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Ms excel find unique records 2 sheets & copy to another sheet
    By tpracsg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2020, 02:53 AM
  2. Copy all records with same date to new sheet
    By soky in forum Excel General
    Replies: 3
    Last Post: 03-20-2012, 05:08 AM
  3. moving all correct records into one sheet and wrong records into one sheet
    By ramserp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2009, 05:31 AM
  4. Replies: 8
    Last Post: 10-31-2008, 12:48 PM
  5. [SOLVED] Counter for records found during Find
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2006, 07:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1