Searching of cells containing 2 strings

[Makafi]

Hi,

I'm asking for help with below.

I'm trying to make a macro, which will:
- take "word1" from inputbox
- take "word2" from inputbox
- search cells in column C in point of occurence of word1 and word2 together in cell
- select rows with cells matching criteria and copy to another sheet.

Using pseudocode I think it should be like this:

inputbox1 = word1
inputbox2 = word2
cell C2 select
if find (word1) = true and find (word2) = true then copy row C else goto C3
if find (word1) = true and find (word2) = true then copy row C else goto C4
...

I assume the answer lies in this thread: http://www.excelforum.com/excel-prog...ple-words.html but don't know how to modify this macro.

Any help would be much appreciated.

Resolved