I'm having this issue that I'm not being able to solve...

I created some sort of dictionary so as to automate a data entry process... A list is created in Sheet 4 which after clicking a button (macro), those values are looked up in Sheet 2 and if they are found, that rows of Sheet 2 are copied to Sheet 5.

I can't figure out how to lookup a value a simple value in Sheet4, in a whole column of Sheet2... That is my major problem, the other part won't be any problem... It's just a copy and paste after all...

THANKS IN ADVANCE