Please find attached the excel file i am working.
I need a macro to do the below task.
if order no (COL B) is same and Invoice No (COL I) is same then check whether Invoice Line Nos (COl J) is in order and not missing say for example it should be like 1, 2, 3, 4 etc..
i only need to check whether if it is 1, 3, 4 order or like that where one or many number is missing from the sequence. Please help.