Excell two workbook difference find with VBA
Project detail
I need to find differences on two workbooks. one is master file with unique ID ( 1800around) and more sample files with unique ID (700 for each file). Master file is fixed value. Sample files is changing every time so i want to find difference on sample file from master file on every week. Only part number (unique ID) is common so vlookup then find all columns difference in different colors.