I have 2 excel file.
- File input (sometimes more than 1 sheets)
- File compare (sometimes more than 1 sheets)
Condition
If Column Cusname and Column APPLAN in file input match with file compare–> Delete row in file input.
Example delete row in yellow highlight because found Cusname = David and APPLAN = BU03 in file compare
Please guide me about it.
input.xlsx (18.8 KB)
File compare.xlsx (18.6 KB)
Remark : I want write output after delete row in same sheet.