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)
Bookmarks