how i make a pgm in excel for copying all the rows to a new file .

[Copying after checking condition in Exce]

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 *** colum as "male". I hope i will get it.
Please

[Don Guillett]

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

The original will remain as before

--
Don Guillett
SalesAid Software
donaldb@281.com
"Copying after checking condition in Exce" <Copying after checking condition
in Exce@discussions.microsoft.com> wrote in message
news:92B12192-EFAF-41B2-AB48-C3B689A69605@microsoft.com...
> 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 *** colum as "male". I hope i will get it.
> Please

[MWE]

Don's solution is simple and nice.