Hi all,

I have multiple sheets in a workbook with multiple coloumns and rows. I
would like to search for a value in lets say coloumn 4. When found it must
return that whole line (or only certain coloumns in that line) on a new
sheet. If it finds a second line with the same value in that coloumn, it must
put it under the previous found line in the new sheet. to build up some sort
of a report with the same values.

Thank you in advance
Johan