Search List, if not in list add to list, if in list add new value

[LeeGro]

I want to write a macro that looks at sheet 1 cell B2 for a value. Then look in sheet 2 for that value in column A. If it finds this value in column A on sheet 2 then input the value of 1 into the cell to the right of it. If it does not find the value of cell B2 from sheet 1 then add it to the bottom of the current list on sheet 2.

[stnkynts]

Please Login or Register  to view this content.