Help in comparing multiple columns in 2 sheets and highlight the mismatch wherever appl..

Hello All,
I am new to Excel formulas, macros and functions.
My job demands to work on excel and I spend a lot of time in doing manual tasks. With the necessity, I have learnt bits and pieces of excel formula and VBA but cant do complex things like this one.

I want to compare 2 excel sheets name "GPGI" VS "GPGK" and find out the mismatch in each column starting from "A" to "J". It should tell me where is the mis match.

How I do manually:

Dirty case:

I go to Column A in GPGI filter for "INF_DTSQ2001" and then go to column A in GPGK and filter for the same. Now When I do that I can see the mismatch like In column A of GPGI at row no. the name is "INF_DTSQ2001" where as in row 2 of GPGK its is "INF_DTSQ2001_NOX". Similarly column B name in both the sheets is different. Like wise I need the data. I have provided my comments in Column L of GPGI.

Clean Case:

When I go and filter for INF_AE3001 in Column A of GPGI and same filter in GPGK everything matches all the cells and columns. So I have provided a comment as "No issue " in Column L of GPGI.

What I have done for time being:

I had done a concatenation formula for both the sheets . Post that I did a vlookup to find out the NA or mis match. But after that also I have to do manual checking for each mismatch and where exactly the mismatch is. if in any column, cell there is a extra space or underscore then that also be highlighted.


Pease see the attached sheet. Please help me here.

Thanks a lot my dear