Condition Met then Remarks in Numerical Series by vba

[Anonymous]

Hi Experts,
I am looking for a macro that will do the things mentioned below

there are 2 files 1.xls & macro.xlsm (macro will be placed in macro.xlsm & macro.xlsx is macro.xlsm file, i was unable to upload macro.xlsm file so i have converted to macro.xlsx for understanding purpose),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)


Thnx For the Help

[grobnik]

Hi Please look the answer to your previous post, the principle it's the same. Bye