+ Reply to Thread
Results 1 to 2 of 2

verify 2 sheet value and return different value to result sheet.

  1. #1
    Registered User
    Join Date
    08-12-2018
    Location
    Taiwan
    MS-Off Ver
    MS 16
    Posts
    8

    verify 2 sheet value and return different value to result sheet.

    hi all, have any idea using VBA for verify two sheet data if it is differect will copy and paste the value to result sheet in TYPE column base on the different value such as Part number,ID ,category or quantity.moreover,attached excel document is a outcome example.



    Thanks and regards,
    Kinder.
    Attached Files Attached Files
    Last edited by [kinder]; 08-12-2018 at 02:08 PM.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,425

    Re: verify 2 sheet value and return different value to result sheet.

    This formula based proposal employs numerous helper columns which may be moved and/or hidden for aesthetic purposes.
    Note that there are no differences between the records for ID's 1006, 1008 and 1009 so I can't help you there.
    1) Columns G:J on the original sheet identify the first difference in ID, Part No, Category and Quantity for an ID between the original and sub sheets using formulas like:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    2) Column G on the Sub sheet identifies New Data using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    3) The range A10:E15 on the Compare Result sheet is populated using:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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