VBA: Cross-match first two sheets and save result sheet as excel workbook.
Crossmatch first ID in ColumnB2/sheetA with all IDs in ColumnB/SheetB and find match/mismatch in a new next sheet "RESULT" and save as MS excel workbook with the name of the first ID in ColumnB2/sheetA.
PS. IDs can also have no data at all in rows in either sheet.
PS. Data can be upto any column.
Reply With Quote
