+ Reply to Thread
Results 1 to 6 of 6

VBA to search duplicate & return all possible results to Main Sheet?

  1. #1
    Registered User
    Join Date
    07-27-2015
    Location
    Sin
    MS-Off Ver
    2010
    Posts
    2

    VBA to search duplicate & return all possible results to Main Sheet?

    Hi all,

    Need some expert help on my current workbook.

    Attached is my current workbook situation. As there's an increase of records and some have same cam ID but they belong to different server & IP address, I need all possible results to be return on the Master.

    Appreciate any one who could help me on this. Thanks much.
    Attached Files Attached Files
    Last edited by beepbeep_go; 07-27-2015 at 09:32 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: VBA to search duplicate & return all possible results to Main Sheet?

    Hi there,

    Take a look at the attached workbook and see if it does what you need.

    Hope this helps - please let me know how you get on.

    Regards.

    Greg M
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-27-2015
    Location
    Sin
    MS-Off Ver
    2010
    Posts
    2

    Re: VBA to search duplicate & return all possible results to Main Sheet?

    Hi Greg,

    This is exactly what I need. Thank you so much!


    Regards.

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: VBA to search duplicate & return all possible results to Main Sheet?

    Hi again,

    Many thanks for your feedback - glad I was able to help.

    Best regards,

    Greg M

  5. #5
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: VBA to search duplicate & return all possible results to Main Sheet?

    Dear friend
    i want to your help to transfer specific data to diffrent cell and diffrent sheet
    see my attached file . there you can see diffrent line name (Line A to line E). i want to transfer All line A data to defined area (master Sheet To To Transfer sheet) . same i want to transfer each line data
    i hope you understand what i need

    see the attachment
    Attached Files Attached Files

  6. #6
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: VBA to search duplicate & return all possible results to Main Sheet?

    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

+ 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. Search multiple tabs using a search box on main Tab to dislay that Tab
    By Nick Harter in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2015, 07:32 PM
  2. Replies: 4
    Last Post: 05-20-2014, 10:03 AM
  3. Replies: 3
    Last Post: 07-17-2013, 03:41 AM
  4. Search Code vba return to the new sheet with duplicate data
    By tantcu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-27-2013, 06:28 PM
  5. [SOLVED] use 2 values on sheet 1 to search sheet 2 & return text on sheet 1
    By BlakeLee in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-02-2013, 04:56 PM
  6. Replies: 2
    Last Post: 11-13-2012, 02:56 PM
  7. Search column a for duplicate data and copy entire row to duplicate sheet
    By crazyAMP in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2012, 08:21 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