+ Reply to Thread
Results 1 to 6 of 6

VBA for finding Duplicates-multiple sheet

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    26

    Post VBA for finding Duplicates-multiple sheet

    Hello

    Need help in finding out duplicate document number & Vendor with value in multiple sheet. Attached sheet for reference.

    rgds
    NGP
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: VBA for finding Duplicates-multiple sheet

    Give an example of what you want the result to be. Do you want duplicate doc #s and duplicate vendors? Duplicate doc#/vendor pairs? Do you want duplicates within sheets? Between sheets? Between and within?
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

  3. #3
    Registered User
    Join Date
    01-19-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    26

    Re: VBA for finding Duplicates-multiple sheet

    The result should be duplicate doc#/vendor pairs within and between sheets

  4. #4
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: VBA for finding Duplicates-multiple sheet

    So, that took longer than I expected. This code should work:
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-19-2011
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    26

    Thumbs up Re: VBA for finding Duplicates-multiple sheet

    it is working, thanks

  6. #6
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: VBA for finding Duplicates-multiple sheet

    Great. Glad I could help If your question has been resolved, please mark this thread as solved and if you feel I've been helpful feel free to give me +Rep.

+ 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. Finding Duplicates Across Multiple Workbooks.
    By sturmy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-24-2014, 10:49 AM
  2. [SOLVED] Finding Duplicates Across Multiple Workbooks.
    By sturmy in forum Excel General
    Replies: 0
    Last Post: 04-24-2014, 09:43 AM
  3. Finding duplicates of multiple col's and moving
    By pauluk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-05-2009, 08:32 AM
  4. Finding Duplicates adding them to another sheet
    By sentinela in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-02-2009, 07:40 AM
  5. Finding Duplicates in Excel sheet
    By rahsa682 in forum Excel General
    Replies: 2
    Last Post: 03-16-2009, 04:26 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