check auto filter or advancedd filter to see if they will do what you want.

"bac" wrote:

Hi

Can anyone please help me with this question. I would like to type a code
in a cell and would like to extract all the rows with that code.

Is this possible or do I need VBA or is there a formula that can do this?

Thanks
Bac