Workbook A,sheet 1
Workbook B, sheet 1
Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A sheet 1
update status as triggered
Output is needed in
Workbook A in a separate sheet 2 ,
Workbook A ,sheet 1, should delete these values which have status triggered
| Supplier | Amount | Owner | status | Date |
| AVT | 500 | John | 4/22/2020 | |
| ABC | 1000 | Peter | 4/21/2020 | |
| NAC | 600 | John | 4/22/2020 | |
| BAT | 10001 | Andrea | 4/23/2020 |
Workbook B, sheet 1
Condition should match Supplier, Amount, Date, If all matches in sheet 1 of workbook B with Workbook A sheet 1
update status as triggered
| Supplier | Amount | Date |
| AVT | 500 | 4/22/2020 |
| UAC | 800 | 4/1/2020 |
| NAC | 600 | 4/22/2020 |
| NAC | 1000 | 3/2/2020 |
Output is needed in
Workbook A in a separate sheet 2 ,
| Supplier | Amount | Owner | status | Date |
| AVT | 500 | John | Triggered | 4/22/2020 |
| NAC | 600 | John | Triggered | 4/22/2020 |
Workbook A ,sheet 1, should delete these values which have status triggered
