+ Reply to Thread
Results 1 to 2 of 2

Comparing Two Sheets with Unique Relationship

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver

    Comparing Two Sheets with Unique Relationship

    Hi All,

    I'm going CRAZY trying to logic this through.

    I have two sheets that have some similar data but is very different from one another.
    I've attached a much simplified example (Also below in text).

    I want to run a macro on Sheets 1 and 2 which will net me a third sheet, showing me the difference between the two.

    Please Login or Register  to view this content.

    How on earth do I do this? Is this even possible?
    Attached Files Attached Files
    Last edited by bobredford; 06-02-2017 at 06:19 PM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac

    Re: Comparing Two Sheets with Unique Relationship

    I don't understand your data.
    For instance do you allow the Sheet2 AD values to be found anywhere in Sheet1.

    In any case this is clearly a much simplified example and probably doesn't represent the size or complexity of your actual data. We often find that when we give an answer to what is a trivial non representative example when the solution is used with the real world data it doesn't work because of factors like string length and other stuff which is important but hasn't been mentioned.

    Therefore upload your real workbook (or at least a cut down copy), and manually add the results you expect to see. Clearly identify which is original data and which are the results and in a note clearly explain how you have arrived at your results.

+ 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. [SOLVED] Check unique relationship
    By fredlo2010 in forum Excel General
    Replies: 7
    Last Post: 03-06-2015, 05:59 PM
  2. Relationship setup to support pivot tables connecting mutliple sheets
    By bjcsoln in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-28-2015, 09:02 AM
  3. Replies: 7
    Last Post: 06-27-2014, 02:26 AM
  4. Relationship between work sheets
    By Boatman in forum Excel General
    Replies: 1
    Last Post: 06-29-2012, 10:50 AM
  5. Creating relationship between 2 sheets of data
    By Evetsllub in forum Excel General
    Replies: 1
    Last Post: 07-14-2010, 04:37 AM
  6. Finding unique names when comparing two lists
    By Fcroft in forum Excel General
    Replies: 2
    Last Post: 01-25-2010, 12:10 PM
  7. Replies: 4
    Last Post: 02-14-2008, 12:28 PM

Tags for this Thread


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