hello ,
thank you alot for help that you provide, could you please help me in this subject:
2 tables with diffrent size
colomn1: contains files_name (first files_name begin at cell A2)
row1: contains code_error_name(first code_error_name at cell B1)
files_name and code_error_name may change position or be deleted between the two sheets so we need to make a search in colomn and rows to comprae data in the 2 tables .
so I guess that the macro need to this , but I can’t do it in VBA
search files_name from colomnA.sheet2 in ColomnA.sheet1
if found
search code_error_name from Row1.sheet2 in Row1.sheet1
if found
recuperate the coordinate of (files_name, code_error_name) from the two sheets than
compare value in cell (files_name, code_error_name) in sheet2 with value cell (files_name, code_error_name) in sheet1 —> than highlight with diffrent color if not equal
do this operation for all the table
you find attached the 2 tablescomp_tab.xlsx
Bookmarks