How to compare row values of multiple columns with the same header in different sheets, even if those columns are only in the same sheet?
Below is the code I have to compare the row values of the columns that have the same header ‘abc’, ‘def’, and ‘ghi’ in ws_checks, assuming those columns are in both Sheet1 and Sheet2. How can it be expanded to compare multiple columns (not just 2, can be any number of columns in 1 sheet or across all Sheets 1 to 5) that share the same column header?