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.