Thank you... is there a way to do this without deleting the original
data on the sheet (ie: I just want to be able to enter the data on the
main sheet and once in a while print out a report of all students who
have passed, or all students who have a fitness pin)
I do not want to change the original data sheet at all if possible



Ron de Bruin wrote:
Hi DyverDown

You can use AutoFilter on the P/F ccolumn and print

Or if you want a seperate sheet see
http://www.rondebruin.nl/copy5.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DyverDown" wrote in message ups.com...
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