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

[DocAElstein]

Using new ( old ) account "Zaeguzah "
https://www.excelforum.com/excel-pro...-the-data.html


Hello Guys,
Looking for a macro

If column B of 1.xls matches with column A of Book1.xlsb & the difference between Column D of 1.xls & Column E of 1.xls is not greater than 0.50% of column D of 1.xls then put Remarks Else Clear the data from Column B of book1.xlsb

Note:
Macro will be placed in a book1.xlsb
Sheet name can be anything
Remarks means If condition met then finding the last row of book1.xlsb and add +1 to the data in the last row & put th result in next cell in that row
clear data means if condition doesnt met then clear all the data in book1.xlsb in that row
Plz see the output (it is the output of the macro)