I would like to run a macro that populates each cell in column M based on the value of column H for the same row. E.g. I need the macro to scan each row in column H with IF (OR(h2 = "5254", h2 = "5255"), "Yes","") in m2 then move on to the next cell till the data finishes.
The range of data can vary week on week.
thanks very much