1. I want to check file B against A, determining if my combination of data in file B corresponds accordingly to file A. If the row in File B contains any error across the columns, I want to highlight it.
2. Both files have the same headers except for File B, there is a unique ID attached which I need. There can be several rows of B that corresponds to a single row of A. Meaning to say A contains unique rows and can contain duplicate rows 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.
3. 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.
2. Both files have the same headers except for File B, there is a unique ID attached which I need. There can be several rows of B that corresponds to a single row of A. Meaning to say A contains unique rows and can contain duplicate rows 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.
3. 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.