Hello guys,

I'm looking for a macro to do the following:

in sheet1, I have column A which contains the row numbers.
I have a column B with the names of persons in it (a certain person can
have multiple lines). I want the macro to go and find all the
rownumbers (in column a) where the name of the person (column b) is
equal to the name given in e.g. cell a1(criteria1) and where column c
fullfils the criteria in cell a2(criteria2). Then all the rownumbers
have to be copied to sheet2 in column A. If the above criteria or not
fullfilled then the rownumber may not be copied to sheet2.


Is this possible ?

Thanks