Clear the data Else put numbers in series

Status
Not open for further replies.

Leonardo1234

Banned
Joined
Jul 28, 2018
Messages
5
Reaction score
0
Points
0
Excel Version(s)
2013
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),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
 

Attachments

  • 1.xls
    25.5 KB · Views: 7
  • Macro.xlsm
    8.8 KB · Views: 8
Status
Not open for further replies.
Top