Paste range of cells that meet criteria

Hi,
I'm having trouble with the programming of my macro. I have the following code

Please Login or Register  to view this content.

The thing is I have in Sheet 1 several rows with the same information. The macro only copies the Cell from Sheet 2 to the first cell in Sheet 1 if it identifies matching the criteria. How can I modify the code so that the macro copies it to all the cells in Sheet 1.

I attach an example of my worksheet.

Hi

Try this

Please Login or Register  to view this content.

rylo