Multiple search criterias.

Hello,

I have a workbook to follow-up my projects.

I would like a macro to : 1/ search in column E the word "on-site" or "workshop" and in column K the word" on-going-
2/ If the two conditions are met, I need to copy in Sheet 2 the columns A, B , E, G, H.

I try to use macros I found on this forum but it did not work.

I attach a sample.

Thanks

works perfectly.

Thank you!

The headings you have in sheet2 do not match with the columns you want to copy.