Macro that compares certain values in a list

[keis386]

Hi,


I tried to make a macro that compares values in a list.

There is a list in sheet 1 and in sheet 2.

If there is a value in sheet 1 and not in sheet 2 add this value in sheet 2


More concrete I made an example:

If there is an "no" in column E the value of column B needs to be in column B in sheet 2*,


*(so if there is a "no" in E2 then value of B2 needs to be in column B in sheet 2, if there is a "no" in E3 then then value of B3 needs to be in column B in sheet 2)

[wallyeye]

You can't just use a formula?

Sheet2!B2:

=if(Sheet1!E2="no", Sheet1!B2,"")