Lookup a coloumn and copy rows to a different sheet

[Guest]

Hi I have a worksheet with a list of components. Each row contains the
component id in the first coloumn. The rest of the coloumns contain other
information. There are several entries with the same component id but
differnet information in the other coloumns. That is, there could be 20 rows
with component id, say R34, but the other coloumns are unique.

I'd like to have a function that looks all the instances of R34 in sheetA,
and copy all the row (including component id), onto sheetB. That way I can
create a sheet for each component id.

 

[Frank Kabel]

Hi
see:
http://www.rondebruin.nl/easyfilter.htm
and
http://www.rondebruin.nl/copy5.htm