Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Macro to compare data

    I have data in Col E on sheet1 and Data in Col A on sheet3

    I would like a macro set up that wil compare these two sets of data and where they differ to extract the data that differs to a sheet called variance

    It must get the following details

    1) The data that appears on Sheet1 Col E and not on Sheet1 Col A and vice versa
    2) The sheet name containing the data apearing on the one sheet and not the other
    3) The row number where the data is different


    Your assistance in this regard is most appreciated

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,198
    Thanks
    48
    Thanked 986 Times in 916 Posts
    I have attached my Compare Data spreadsheet. You can use it as required.

    cheers, Paul
    Attached Files Attached Files

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Hi Paul

    Thanks for the reply & your spreadsheet, which will be a great help

    Regards

    Howard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •