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

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)

hlkhlhh

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

If column E of sheet3 of 3.xlsm matches with sheet4 of Column B of 10.xlsx then match the same with column B of sheet1 of 3.xlsm & if matches then put the numerical data in series by vba in sheet1 of 3.xlsm

Macro will be placed in 3.xlsm file


Thnx Alot
https://www.excelforum.com/excel-pro...dding-1-a.html

Probelm Solved
Thnx Alot

Quote:

---

Originally Posted by fixer

Probelm Solved..

---

You forgot ( again ) to tell us all how it was solved it and where you got the solution...