vba Copy Paste Conditional to put remark 1 2 3 .. etc

[DocAElstein]

Here’s a few of the identical cross posts on a new question.
there are 2 files 1.xls & macro.xlsm (macro will be placed in macro.xlsm),both files are located in different places so the path will be hardcoded in the macro so that i can change it as per my needs

sheet name can be anything plz see the sample file
Condition: If column D of 1.xls matches with column E of 1.xls Or If column D of 1.xls matches with column F of 1.xls then match column I of 1.xls with column B of Macro.xlsm & if it matches then clear all the data in that row from column C
Or
If column D of 1.xls does not matches with column E of 1.xls & with Column F of 1.xls too.. then put the remarks in series (numerical series)
https://www.mrexcel.com/board/thread...y-vba.1141539/
https://www.excelguru.ca/forums/show...bers-in-series
https://www.myonlinetraininghub.com/...bers-in-series
https://www.experts-exchange.com/que...es-by-vba.html
https://www.excelforum.com/excel-pro...ml#post5371511 ( Closed by Jeff in error )
http://www.eileenslounge.com/viewtopic.php?f=30&t=35053