Copy and paste every cell in the column that constains specified value to other worksheet

[nosense]

Hi guys,

I am trying to write a code that will find a text values ("As wound") in entire column "L" and will copy every entry that is in the column "F" equivalent to the same row. This code does not doing it it is only pasting the first looked up value instead of all

My code

Please Login or Register  to view this content.

[skywriter]

You can try this. If it doesn't help you should post a sample worksheet so we can see your data.

Please Login or Register  to view this content.