Hi,

I'm figuring out a way (VBA) to replace (or not replace ) the values of different types of machines if the value in another sheet of the same machine is bigger than e.g. 1. If not, then it should hold the same value. For example: In destination-sheet 1 Column A consists of list of (different) machines, Column B the values. In the everchanging source-sheet there is the same list (or bigger or other sorting) in Column A type of machines and Column B the values.

So first it has to find the same type of machine for every cell in column A in sourcesheet and then check the value in Column B sourcesheet (bigger than 1) than replace if condition meets. If not, keep existing value.

I thought that a vloopupfunction doesn't work as it always replaces the cell value and/or cannot keep the same value if the condition doesn't meet.

Thanks!