Userform2 is a listbox filled with project #'s. The selected #'s then fill Column "A" of a sheet called "Project2".
Sheet "DM", column "P" is populated with an unknown amount of different project #'s. These change each week.

I am comparing column "A" from "Project2" with column "P" from "DM". If there is a match, it does nothing, if there is not a match, it hides the entire row.

The code is working,however, it is only matching the last value in column "A" of "Project2" instead of all of the values(I made sure to choose values that do exist in the "DM" sheet). 


Please Login or Register  to view this content.
Any help would be appreciated. I am not sure where I am going wrong here.