I am trying to determine if data Excel file B is correct relative to excel file A. Both files have the same headers except for File B, there is a Unique ID & Sub ID Group attached. There can be several rows of B that corresponds to a single row of A. Meaning to say A contains unique rows and B can contain multiple entries of A with a Unique ID for each row. Is there any way to automate the checking process using Excel formulas or VBA? I need to highlight the rows in B that do not correctly match its respective row in A.
I need a formula to search file A for the combination and not just one row...E.g row 23 on File A may contain the combination I want the formula to see that row 3 on 'sheet 2' contains the same combination and return the yes or formula to see that the combination does not exist in rows 3 through 200 and return a NO and highlight it
TLDR:
Is there a way for me to automate checking? If the data combination in each row cannot be found in reference File A, I need to highlight it. This is a HR file, Drilling down from Macro to Micro organization breakdown.
Bookmarks