One simple way would be to
sort by that column
delete all not desired
filesaveas"male"

The original will remain as before

--
Don Guillett
SalesAid Software

"Copying after checking condition in Exce" <Copying after checking condition
in wrote in message
...
Please help me to make a pgm to make a new file from an old file by
clicking
a button. The new file will be containing all the rows of the old file
which
satisfying the condition, second cell of the row is "male" . For egs: we
are
entering details of students. For getting list of male students, we can
take
all the rows which contains the sex colum as "male". I hope i will get it.
Please