Condition met then put the remarks Else clear the data by vba

[zyxw1234]

Hi Experts,

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)

Thnx For the Help

[HansV]

You have asked similar questions before. It's time that you solve such problems yourself.

[zyxw1234]

Yes i asked the question but both are different & this is a new variation qunique from all other variation so i was unable to do so
thats y i asked for help

[HansV]

The purpose of a forum like this is to help you on your way, not to write code for every tiny variation of a problem for you. As has been pointed out to you before, if you are not able to do that, you should hire someone to write code for you instead of asking virtually the same question over and over again on multiple forums.

[Leif]

And locked to save wasting anyone's time.