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 sex 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
(e-mail address removed)
"Copying after checking condition in Exce" <Copying after checking condition
in (e-mail address removed)> wrote in message
news:[email protected]...