I have a list of students names in columns with their run time and
other physical tests along the row. The sheet uses a vlookup table to
calculate their scores and from their scores, determines if they pass
or fail and if they pass, if they are to receive a fitness pin "Y".
There are columns for each fitness test, a column for their final
score, a column for "Y" or "N" for a fitness pin and a column for
"P"ass or "F"ail.


I would like to copy from the main sheet to another sheet (for
printing) all those students who passed "P" and all those students who
received a fitness pin (either separate new sheets or the same new one)

How can I do this?

HELP...

-Michael