Hi
See annexed need to compare column C.F,G,I.
Column C represent productCode.
Column F represent % of Tax
Column G represent the code Classifcation for applicable tax %
That is column F and G are related.
Column I represents suppliers.
What I am expecting is to compare these columns mentioned above and to hightlight differences in these columns and produce a summary of differences to sheet 2 with their respective headers.
Note the record reads 30000 rows .
I have highlighted in red sample as diffrence to be more explicit what I am expecting .
Thanks in advance for those who can help to solve.
See annexed need to compare column C.F,G,I.
Column C represent productCode.
Column F represent % of Tax
Column G represent the code Classifcation for applicable tax %
That is column F and G are related.
Column I represents suppliers.
What I am expecting is to compare these columns mentioned above and to hightlight differences in these columns and produce a summary of differences to sheet 2 with their respective headers.
Note the record reads 30000 rows .
I have highlighted in red sample as diffrence to be more explicit what I am expecting .
Thanks in advance for those who can help to solve.