If you need to take an entire row of information (all males) and get it to
another sheet, use an Autofilter. You can specifiy just about any criteria
and the whole row is visible for copy/paste
--
Gary''s Student - gsnu200732


"Yan" wrote:

I need to find all female and all male that is on 1 sheet and created the
result onto the other sheet.....

I need to take all info beside each F and created a list and Each M beside
the name a created a list into another sheet, all the information beside need
to be taken as well....

Basically,



Ex:
M Yan 252 3000
M BOB 246 25500

F Kim 256 30124
F Pat 300 25466