[RESOLVED] Cut & paste the data to new sheet if condition matches

[mail2tradesmart]

Hi Experts,

I am looking for a macro that will do the things mentioned below
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 & the output file


If column D of 1.xls equal to column E of 1.xls or column D of 1.xls equal to column F of 1.xls then cut that row & paste it to new sheet in 1.xls(Plz name the new sheet as output2)
(header will be same in new sheet also)




Thnx For the Help



https://drive.google.com/file/d/15LM...ew?usp=sharing
https://drive.google.com/file/d/1ifJ...ew?usp=sharing