Maybe you could select your range and do
Data|filter|autofilter

Then filter to show the value that 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

--

Dave Peterson