table(A) as an array using all rows but only selected columns to compare with table(B)

Hi All

Would like some help on problem. Need to compare two tables values.
table(A) is in sheet 1 which is from a data base exported into excel the table has fixed columns(A to T) but the row can be varied number.

Table(b) is in sheet 2 and has 5 columns(A,B,C,D,E) and various row as a validating reference for data in Table(A).

Am trying to compare table(A) by selecting specific columns only from this table to those in table(B) in sheet 2 so I end up the with
the same number of columns and data types in the array to the make comparison to table(b).

I need only 5 columns (A,C,G,F,M)from table(A) and as rows looped in into an array i need to have value compared to table(2) for each row
looped any value not exact in table(b) need displayed in sheet 3.

Any Help very much appreciated.

Thank you.

Hi,se3unlock

I'm not very clear about your desire, hope this is code you wanted

hi thank you for the reply
am sorry for not being very clear to the objective.

am trying check the row data of 5 columns table A(sheet 1) with table b(sheet 2) and the data that is not coresponding in comparing the row of the 5 columns the result to sheet 3

table a table A.jpg
table b table b.jpg
sheet 3 result sheet 3 result.jpg

I hope this will helps in getting an understanding of am trying to get to.

any help with this very welcome.

thanks

attachments will be helpful to understand, especially for me

Hi Simcode
thank you so much it works, could I ask you one more thing would it be possible to have in sheet 3 extra column which would display the comparison column names that did not equal from sheet 1 and sheet 2 as this will give indication why the data is in sheet 3 if it possible.

once again thank you so much for your reply and solution.

Hi, se3unlock

Giving the column names that values diff from two sheets is possible, but the program is a little bit long,and wordy.

WOW SIMCODE
Brilliant work on solution.

Many thanks.

You're welcome.